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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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