Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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?
Solved! Go to Solution.
Hi,
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
Hi guys, it is fine you found the solution at Microsoft, but it doesnt work this way.
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
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,
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
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:
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
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
100 | |
65 | |
44 | |
36 | |
36 |