Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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.
Solved! Go to Solution.
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 ..
Have you update ?
thanks
Hi, we have same problem in RI Usage Details, error:
Expression.Error: The column 'InstanceId' of the table wasn't found.
Details:
InstanceId
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?
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
Also facing same issue since yesterday's refresh.
Microsoft, can you please provide any ETA for resolution?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.