We cannot convert the value null to type table

[MattS-GSC]

🐛 Problem

We setup the finops hub with Microsoft a few days ago and the finops hub is not working, we re-downloaded the reports and each one we load has the error "1 query is blocked by the following errors" as shown in the below screenshot.

👣 Repro steps

Open the report, follow the steps to load the report.

🤔 Expected

I expect the reports to load without error.

📷 Screenshots

ℹ️ Additional context

I re-downloaded the reports, emptied the storage account, validated our export config (focus, parquet etc), re-exported the data and ran the reports, same error.

[MattS-GSC]

The image under problem is cost summary.

This is Rate Optimization:

[flanakin]

@MattS-GSC Can you follow the debugging steps in this issue and share screenshots of what you see?

#1359

#needs-info

[MattS-GSC]

I made this change:

to

Now this is the error message on the right:

[flanakin]

@MattS-GSC A few things:

1. Did you set the RangeStart, RangeEnd, or Number of Months parameters?
2. Can you select the "start" and "end" steps and share the values they show?
3. Can you select the "Source" step and confirm if you see data?

Looking at the code, I don't see anything wrong. I'm wondering if the RangeStart/RangeEnd parameters aren't being processed correctly.