Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JasonSquires
Advocate I
Advocate I

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

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 as
https://community.fabric.microsoft.com/t5/Desktop/Azure-Cost-Management-RI-Usage-Details-400-Bad-Req...

Even 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.

1 ACCEPTED SOLUTION

I can cofirm success as well.

View solution in original post

26 REPLIES 26

I have the same problem from last 3 days
Last usefull update was March 9, 2024 

hello 

I have the same problem since three days ..

fabiengouineau_0-1710218745090.png

Have you update ?

thanks

 

unascimento
Frequent Visitor

Hi, we have same problem in RI Usage Details, error:

 

Expression.Error: The column 'InstanceId' of the table wasn't found.
Details:
InstanceId

unascimento_0-1710261081507.png

 

alexmorgan_uoe
New Member

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?

Warren_Graham
New Member

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

majknowak
Regular Visitor

Also facing same issue since yesterday's refresh.

Microsoft, can you please provide any ETA for resolution?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.