I have an automated Azure Cost Analysis report that just started failing on refresh this past weekend. The error states that RI Usage Details DataSource.Error: Web.Contents failed to get contents from 'https://management.azure.com/providers/Microsoft.Billing/billingAccounts/xxxxxxxx/providers/Microsoft.CostManagement/generateReservationDetailsReport?api-version=2019-11-01&startDate=2023-09-01&endDate=2024-03-11' (400): Bad Request Expression.Error: The column 'InstanceId' of the table wasn't found. Details: InstanceId I know that there are resolutions for similiar issues in the past such ashttps://community.fabric.microsoft.com/t5/Desktop/Azure-Cost-Management-RI-Usage-Details-400-Bad-Request/td-p/1862163Even if I try the above solution, I still get the same error. If I just do one day 3-9-2024 to 3-11-2024 I get the same error. It seems that RI Usage Details backend call is broken.

Azure Cost Management - RI Usage Details - Column InstanceId Not Found

26 Replies

JasonSquires
Advocate I
2 years ago
To keep others updated, I was just finally able to get a ticket opened up with them.
SYSOPDAV
Regular Visitor
2 years ago
Hi Guys, now it works.
😃

I don't know if any of our tickets were lucky.
I've tried to refresh the data and it works from both PowerBI Desktop and PowerBI Portal.
Of course, I didn't do anything on my dashboard or imported data
- JasonSquires
  Advocate I
  2 years ago
  I can cofirm success as well.
unascimento
Frequent Visitor
2 years ago
People, today in new test of refresh is ok. You can retry refresh all (power query editor) in this table and apply again in Power BI Desktop or Online ? for me resolve..

Thanks
unascimento
Frequent Visitor
2 years ago
Hi, today in new test of refresh is ok. You can retry refresh all (power query editor) in this table and apply again in Power BI Desktop or Online ? for me resolve..

Thanks
Anonymous
Not applicable
2 years ago
Also facing same issue since yesterday's refresh.

Microsoft, can you please provide any ETA for resolution?
Warren_Graham
New Member
2 years ago
Hi,

today I've experienced exacly the same error. It gets broke when navigate to table data for key="riusagedetails".

Error info:

Expression.Error: The column 'InstanceId' of the table wasn't found.
Details:
InstanceId
alexmorgan_uoe
New Member
2 years ago
Also facing the same issue error occurred while processing the dataset:
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
[ValidateMarkupTags]<ccon>[ccon]Expression.Error: The column '[ccon]InstanceId[/ccon]' of the table wasn't found.. [ccon]InstanceId[/ccon]. [/ccon]. The exception was raised by the IDbCommand interface.</ccon> Table: RI usage details.

Microsoft, can you please provide any ETA for resolution or a workaround please?
unascimento
Frequent Visitor
2 years ago
Hi, we have same problem in RI Usage Details, error:

Expression.Error: The column 'InstanceId' of the table wasn't found.
Details:
InstanceId
gondolf
Regular Visitor
2 years ago
I have the same error too:
Expression.Error: The column 'InstanceId' of the table wasn't found
- SYSOPDAV
  Regular Visitor
  2 years ago
  I have the same problem from last 3 days
  Last usefull update was March 9, 2024
- fabiengouineau
  New Member
  2 years ago
  hello
  I have the same problem since three days ..
  Have you update ?
  thanks
hly
Frequent Visitor
2 years ago
Same, we are running into the same issue.

Microsoft can we please have this fixed ASAP?
- hly
  Frequent Visitor
  2 years ago
  I'm now getting the following error instead of the InstanceID error:
  Expression.Error: We cannot apply field access to the type Null.
  Details:
  Value=
  Key=status