topic Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found in Developer

Azure Cost Management - RI Usage Details - Column InstanceId Not Found

JasonSquires — Mon, 11 Mar 2024 09:59:44 GMT

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-Request/td-p/1862163

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.

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

Anonymous — Mon, 11 Mar 2024 10:00:37 GMT

Also facing same issue since yesterday's refresh.

Microsoft, can you please provide any ETA for resolution?

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

Warren_Graham — Mon, 11 Mar 2024 10:01:00 GMT

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

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

alexmorgan_uoe — Mon, 11 Mar 2024 16:12:06 GMT

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?

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

unascimento — Tue, 12 Mar 2024 16:31:27 GMT

Hi, we have same problem in RI Usage Details, error:

Expression.Error: The column 'InstanceId' of the table wasn't found.
Details:
InstanceId

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

gondolf — Mon, 11 Mar 2024 22:27:52 GMT

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

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

hly — Tue, 12 Mar 2024 01:29:14 GMT

Same, we are running into the same issue.

@Microsoft can we please have this fixed ASAP?

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

hly — Tue, 12 Mar 2024 04:33:53 GMT

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

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

fabiengouineau — Tue, 12 Mar 2024 04:46:39 GMT

hello

I have the same problem since three days ..

Have you update ?

thanks

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

fabiengouineau — Tue, 12 Mar 2024 04:47:23 GMT

Hello

I have the same problem since three days ..

Have you update ?

thanks

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

SYSOPDAV — Tue, 12 Mar 2024 09:28:54 GMT

I have the same problem from last 3 days
Last usefull update was March 9, 2024

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

SYSOPDAV — Tue, 12 Mar 2024 09:44:07 GMT

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

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

lluisak — Tue, 12 Mar 2024 10:28:20 GMT

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

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

SYSOPDAV — Tue, 12 Mar 2024 11:22:36 GMT

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

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

JasonSquires — Tue, 12 Mar 2024 11:43:38 GMT

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.

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

unascimento — Tue, 12 Mar 2024 16:30:31 GMT

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

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

JasonSquires — Tue, 12 Mar 2024 17:46:13 GMT

I finally got a ticket open with them.

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

JasonSquires — Tue, 12 Mar 2024 17:47:45 GMT

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

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

MikeKuan — Wed, 13 Mar 2024 05:52:59 GMT

I have temporarily disabled the table RI_USAGE.

Re: Azure Cost Management - RI Usage Details - Column InstanceId Not Found

SYSOPDAV — Wed, 13 Mar 2024 08:07:48 GMT

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