Azure Cost Management - RI Usage Details - 400 Bad Request

[vojtechsima]

Hi,

I wanna get data from Azure Cost Management, I use Enrollment Number and I have no problem getting other Tables (RI summary or Usage Details), however, for RI Usage Details I receive this error:

DataSource.Error: Web.Contents failed to get contents from 'https://management.azure.com/providers/Microsoft.Billing/billingAccounts/8735269/providers/Microsoft.CostManagement/generateReservationDetailsReport?api-version=2019-11-01&startDate=2018-05-01&endDate=2021-05-25' (400): Bad Request

Could you please clarify what's the issue?

[skerko]

Hi guys, it is fine you found the solution at Microsoft, but it doesnt work this way.

[v-luwang-msft]

Hi @vojtechsima ,

Awesome! You can mark your answer as the correct answer so that users with the same problem can find a solution as soon as possible.

Best Regards

Lucien

[v-luwang-msft]

Hi @vojtechsima ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regards

Lucien

[vojtechsima · Accepted solution]

Hi,

@v-luwang-msft 

I got it resolved by this article:

let
    enrollmentNumber = "<<Enrollment Number>>",
    optionalParameters1 = [startBillingDataWindow = "-9", endBillingDataWindow = "-6"],
    source1 = AzureCostManagement.Tables("Enrollment Number", enrollmentNumber, 5, optionalParameters1),
    riusagedetails1 = source1{[Key="riusagedetails"]}[Data],
    optionalParameters2 = [startBillingDataWindow = "-6", endBillingDataWindow = "-3"],
    source2 = AzureCostManagement.Tables("Enrollment Number", enrollmentNumber, 5, optionalParameters2),    
    riusagedetails2 = source2{[Key="riusagedetails"]}[Data],
    riusagedetails = Table.Combine({riusagedetails1, riusagedetails2})
in
    riusagedetails

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management 

[v-luwang-msft]

Hi @vojtechsima ，

The same problem occurred in February and the support department mentioned 60 to 90 days for a fix ,you could see the below:

Azure Cost Mgmt Power BI

Root Cause:

the issue is  on the Azure cost management APIs for payloads processing  , due to a backend (db) change on Azure cost Mgmt API side  , which essentially caused wrong response codes  on attributes on their end leading to NULL

attributes being passed and causing casting error when responding to payload requests from PBI calls. 

Wish it is helpful for you!

Best Regards

Lucien