search

microsoft / finops-toolkit

Tools and resources to help you adopt and implement FinOps capabilities that automate and extend the Microsoft Cloud.
https://aka.ms/finops/toolkit
MIT License
304 stars 105 forks source link

An error occurred in the ‘ftk_LoadData’ query. Expression.Error: We cannot convert the value null to type Table. Details: Value= Type=[Type] #999

Closed highsmithjd closed 1 month ago

highsmithjd commented 1 month ago

I've set up the FinOps Hub. Data is in the ingestion container as a parquet file. I can access the data with the cost summary report so permissions are fine and the data looks good. When i try and use the FOCUS report i get the following error:

An error occurred in the ‘ftk_LoadData’ query. Expression.Error: We cannot convert the value null to type Table. Details: Value= Type=[Type]

I've seen a previous issue in GitHub and nothing seemed to fix my problem. Any help is much appreciated. Thanks!

JAK1047 commented 1 month ago

Same issue only in the RateOptimization report. The CostSummary one works fine.

arthurclares commented 1 month ago

@highsmithjd What's the Hub and Report version that you are running? You can check the Hubs version by looking at the settings.json inside of the config container. To check the report version, just open it on PBI desktop and look at the "Get Started" page. There is a little "version" at the top image

highsmithjd commented 1 month ago

Microsoft support said the FOCUS report does not work with FinOps Hub 2.0 or greater. The FOCUS report is merged into the Cost Summary report.