Forum Discussion

sremene's avatar
sremene
New Member
6 years ago

Azure Cost Management : Balance Summary

Hello,

 

I recently started using the Azure Cost Management connector for Power BI ti get some Azure consumption data for my EA. I'm getting the following mistake when trying to retrieve the data form the table "Balance Summary":

 

This is what i do :

 

I enter my EA and I specify that I want to recover the last 12 months

 

But I recover only the last month as you can see in the following screenshot.

 

 

I have this problem only with the table "Balance summary". No problem with other tables like "Usage detail".

 

I want to clarify that I do not have this problem with the old connector "Azure Consumption Insights (Beta)"

 

Any suggestions will be appreciated.

4 Replies

    • sremene's avatar
      sremene
      New Member

      Hi Bahneby,

       

      No. I think the problem is not with PowerBi but with the Microsoft Azure Billing API. I opened a support ticket but it's last one didn't help much. I'm still using the old API for now.

       

      Stéphane

  • Anonymous's avatar
    Anonymous
    Not applicable

    I agree, I specified 3 months, but only current month returned. Might be a good idea to log a call with Microsoft and ask if they can fix the Balance Summary for Azure Cost Management connector for Power BI . 

    As an interim measure append the data in Power BI for each month so you have history for 12 months.