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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.