Skip to content

finops toolkit 0.9 - DataIngestion.kql - HubScopes: Expression.Error: We cannot convert a value of type Record to type Text #1521

Description

@defenestration

🐛 Problem

DataIngestion.kql.pbit From the PowerBi Kql queries gives me an error. I have configured serveral subscription scopes in the settings.json, and this seems to work fine for ingesting data with AzureDataFactory. I followed directions and downloaded the dashboards for finops toolkit 0.9.

error is for the HubScopes source:

Expression.Error: We cannot convert a value of type Record to type Text.
Details:
    Value=
        scope=/subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
    Type=[Type]

👣 Repro steps

  • Load in DataIngestion.kql.pbit to powerbi
  • configure the data sources,
  • get the error below.

🤔 Expected

No error

📷 Screenshots

Image

ℹ️ Additional context

I am using the CostSummary.kql dashboard without issues currently, so don't think it is something wrong with the data.

🙋‍♀️ Ask for the community

We could use your help:

  1. Please vote this issue up (👍) to prioritize it.
  2. Leave comments to help us solidify the vision.

Metadata

Metadata

Assignees

Labels

Type

No fields configured for Bug.

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions