cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vojtechsima
Super User
Super User

Azure Cost Management - RI Usage Details - 400 Bad Request

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?

1 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 

View solution in original post

4 REPLIES 4
v-luwang-msft
Community Support
Community Support

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
Community Support
Community Support

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

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
Community Support
Community Support

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

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!