Azure Cost Management - Balance Summary, show previous months

Question

When using the Azure Cost Management connector with Power BI, I want to get "Balance Summary" for previous months.

When I choose to get data from 4 months back, I only get data for current month. Usage Details and the other data tables works fine, except Balance Summary.

I need help to get Balance Summary for all the selected months

Answer 1

As mentioned earlier, Currently, this is a limitation for Balance Summary in Power BI. Appreciate if you could share your valuable feedback here - https://feedback.azure.com/d365community/forum/748a4eaa-0e25-ec11-b6e6-000d3a4f07b8 that way your feedback gets conveyed to the product group and there are high possibilities that the feature gets prioritized and be added in the near future.

Reference from - https://community.powerbi.com/t5/Desktop/Azure-Cost-Management-Balance-Summary/td-p/1062550 "As an interim measure append the data in Power BI for each month so you have history for 12 months."

Hope this helps!

Answer 2

Hello @Martin Sivertsen - Thank you for contacting us!

I know that you are looking for balance summary for previous months. Currently, this is a limitation for Balance Summary in Power BI.

Below is PG advise:

The call by Billing Account Balances - Get By Billing Account - REST API (Azure Consumption) | Microsoft Learn gives current month data only.

To get data for other billing periods, please use this API Balances - Get For Billing Period By Billing Account - REST API (Azure Consumption) | Microsoft Learn

Hope this helps!

----------------------------------------------------------------------------------------------------------------------

If the response helped, do "Accept Answer" and up-vote it