Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

PowerBI Desktop to pull Azure billing data

I have been using the Azure Enterprise GetData to pull Azure Summary Billing data from ea.azure.com but it looks like in December Microsoft has removed this GetData connector from the Desktop clients and its now failing.

 

Microsoft has recommended that I switch to using https://consumption.azure.com/ to pull the summary data. However I have not been successful in making this work.

 

Can anyone provide me the steps to use this?

 

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    I ended switching to using json to pull the data through the API and this has let me pull the data but I have another issue that I will post as a seperate question. THanks for everyones assistance.!

     

13 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi, Below is the error I recieve when I try the instructions you sent. I thought maybe it was a privilige issue but I have the same privliges I had when I was using the ea.azure.com API, is this one different?

       

       

       

      I have tried the following but still recieve the same error

      - Temperary they have give me Admin rights

      - Did a regenerate on the key even theough the old one didnt expire until Apr 2018

       

       

       

       

       

      • stretcharm's avatar
        stretcharm
        Memorable Member

        I've not used the azure billing for a while, but it worked fine when I first set it up. I tried both the desktop connector and the Microsoft Azure Enterprise get data service on the cloud.

        Does your accout work with the cloud service?

         

        My key has expired so I cannot currently test it.