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
unascimento
Frequent Visitor

Hi, today in new test of refresh is ok. You can retry refresh all (power query editor) in this table and apply again in Power BI Desktop or Online ? for me resolve.. 

unascimento_0-1710360381285.png

 


Thanks

unascimento
Frequent Visitor

People, today in new test of refresh is ok. You can retry refresh all (power query editor) in this table and apply again in Power BI Desktop or Online ? for me resolve.. 

unascimento_0-1710360261357.png


Thanks

 

SYSOPDAV
Regular Visitor

Hi Guys, now it works.

😃

SYSOPDAV_0-1710342310787.png

 


I don't know if any of our tickets were lucky.
I've tried to refresh the data and it works from both PowerBI Desktop and PowerBI Portal.

Of course, I didn't do anything on my dashboard or imported data

I can cofirm success as well.

hly
Frequent Visitor

I couldn't wait any longer for Microsoft to resolve the issue. I realised that my dashboard does not use any data from RI Usage Details and RI Usage Summary... so I removed both tables. My dashboard refreshes fine. I would only recommend you do this if you do not use either tables mentioned above.

fred85
New Member

same error 

rondouglas
Regular Visitor

Same error for me, raised a support ticket and not really getting anywhere with them.

 

I generated a RI Usage Details report from the API and it has no column InstanceId, seems to have been renamed InstanceName. So that would suggest the data is messed up - but the support team are not escalating it, as they dont seem to grasp the issue.

MikeKuan
New Member

I have temporarily disabled the table RI_USAGE.

JasonSquires
Advocate I
Advocate I

To keep others updated, I was just finally able to get a ticket opened up with them.

unascimento
Frequent Visitor

We have same problem since 09 march.. last update with success... Microsoft ? 

SYSOPDAV
Regular Visitor

Has anyone already opened a ticket with Microsoft for this issue?

If I do not see any results by the time my job runs this morning, I will be calling Premier support to see if they can help. I am going to direct them directly to this thread.

I finally got a ticket open with them.

Me too.
Yesterday afternoon I opened a tickted with Premier Support (now Unified Support)

lluisak
New Member

Same issue here , thanks for raising this loop, I hope Microsoft can fix soon. 

SYSOPDAV
Regular Visitor

Hello guys
Are we the only ones in the world who have this problem?

 

fabiengouineau
New Member

Hello 

I have the same problem since three days ..

fabiengouineau_0-1710218835997.png

 

Have you update ?

thanks

hly
Frequent Visitor

Same, we are running into the same issue.

 

@Microsoft can we please have this fixed ASAP?

hly
Frequent Visitor

I'm now getting the following error instead of the InstanceID error:

Expression.Error: We cannot apply field access to the type Null.
Details:
Value=
Key=status

gondolf
Regular Visitor

I have the same error too:
Expression.Error: The column 'InstanceId' of the table wasn't found

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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