DataIngestion PowerBI Report #1043
-
|
Testing out the DataIngestion PowerBI report, I am receiving an error in the HubScopes query. My scope appears as a record and on the step: = if ADLS = null then null else Table.TransformColumns(Scope,{{"Scope", Text.Lower, type text}}) I receive the error: Expression.Error: We cannot convert a value of type Record to type Text. In general, ingestion is working as expected with the current scope configuration. Thanks in advance. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 4 replies
-
|
Is this with 0.6? I'm aware of an issue there. Ingestion paths were changed but the Data ingestion report wasn't updated. |
Beta Was this translation helpful? Give feedback.
-
|
@calVertical I spent some time on this yesterday and updated the latest Data ingestion report (PBIX / PBIT). Please download the latest. Thanks for reporting this and sorry about the inconvenience! |
Beta Was this translation helpful? Give feedback.
-
|
Thanks for the quick response! I'm running on version 0.5.
|
Beta Was this translation helpful? Give feedback.
-
|
I also got the same issue with a single billing account scope in v.0.6 of FinOps toolkit reports. I believe it is connected with having to adjust the settings.json to use a record for the scopes. Otherwise the config-pipeline in ADF did not work. I fixed the issue by adding a step to the report that expands the record to a column (see content from advanced editor below): 
I don't know if this is a long term solution, but it got me past the issue. |
Beta Was this translation helpful? Give feedback.
-
|
We're about to ship 0.8 which. Let us know if you run into any issues there. I'll mark this resolved for now since we haven't heard back but please do create a new thread or issue if you run into problems or have any questions. |
Beta Was this translation helpful? Give feedback.
Is this with 0.6? I'm aware of an issue there. Ingestion paths were changed but the Data ingestion report wasn't updated.