Search code examples
azurepowerbipowerbi-datasourcecost-management

Failed to update data source credentials: The column 'budgetAmount' of the table wasn't found - Power BI Azure Cost Management Connector

I started using the Azure Cost Management Connector for Power BI. I could use it without an issue on Power BI desktop and import data into my report. However, when I published the report, it gives me the following error:

enter image description here

My report is pretty basic. It only has Azure Cost Management Connector as a data source. As far as the visuals go, I only have a simple table; no transformations, no customizations whatsoever.

But the problem is, I don't have any column named 'budgetAmount' any of my tables. I tried "Edit Credentials" option in the Dataset section of the report in Power BI report. It successfully logs me in but then throws this error. I'm only using the Usage Details from the Azure Cost Management connector.

Has anyone else faced a similar situation?

Solution

  • 02/24: This issue is fixed and rolled out, make sure to install the latest PBI desktop from here

    https://www.microsoft.com/en-us/download/details.aspx?id=58494
    enter image description here
    -------------------------------------------------------------------------------------------------------------------------------
    The issue happens because there is no budget available under the "Cost Management -> Budget". Until we get out a fix the workaround for now is to add a test budget in the azure portal and the report should start working.

    Steps to setup budget

    https://learn.microsoft.com/en-us/azure/cost-management/tutorial-acm-create-budgets