search

chris-bowman / Azure-Cost-Reporting

150 stars 43 forks source link

Using MCA - several errors occur on data retrieval 'We cannot convert the value null to type List.' #18

Open BristleBeard opened 1 year ago

BristleBeard commented 1 year ago

When I first input the details to connect, I get a dialogue that '2 queries were blocked by the following errors'. The errors are all about converting the value null to a type List. Each of the sections below are part of it.

Pricesheet RI Transactions RI Usage RI Recommendations RI Recommendations (Shared) Usage Details Usage Details Amortized

chris-bowman commented 1 year ago

Hi @BristleBeard, does it have any other details on what is causing it to fail? Can you try to run Query Diagnostics for the one of table loads and check which step/API is failing for the bad request? Pricesheet would probably be a good start as it's a smaller table