400 Error in PBI refresh

Naila Zeeshan 0 Reputation points
2024-10-01T23:53:11.48+00:00

Hi, we are Azure Cost Management as a data source in our PBI report. Report has failed to refresh today with following errors:
Web.Contents failed to get contents from 'https://management.azure.com/providers/Microsoft.Billing/billingAccounts/86861053/providers/microsoft.consumption/balances?api-version=2019-10-01' (400): Bad Request

How can we resolve this error?

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,568 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Ryan Hill 28,106 Reputation points Microsoft Employee
    2024-10-03T01:25:57.9166667+00:00

    Hi @Naila Zeeshan

    Without knowing more behind the 400, best thing I would do is run the API using the Try It feature in Balances - Get By Billing Account REST API docs, see if you get the same response. Since the api-version is later than what your PBI is using, you can adjust version to see if that's issue or not. It could be an issue with the API version, or it could an issue with the billing account you're passing.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.