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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors
Users online (770)