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?

avatar user

Helpful resources

Announcements
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!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)