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...
Need Help
  • 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.!

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Got it, I tried this using the Microsoft Azure Consumption Insights with the PowerBI Web and it did work. However, this wont work for me as I have spent a substnatial amount of time building out the Desktop solution for charging out all of our Azure costs to the different departments in our company and Im pulling data from several internal systems including some Excel files.

 

The Desktop Microsoft Azure Enterprise connect worked perfectly for me, I dont understand why Micoroft removed this. Any suggestions on how to make the Desktop work?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks, but I get the exact same error

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

    Please use Fiddler to capture the trace and share the trace file to us. 

    Regards,
    Lydia

  • stretcharm's avatar
    stretcharm
    Memorable Member
    8 years ago

    Hi,

     

    I've just updated all api key and my old powerbi doc works.

    I basically get the details for my report.

     

    This is the basics of what I'm using.

     

    let
    Source = AzureEnterprise.Tables("https://ea.azure.com/rest/??EnrNo??"),
    Detail = Source{[Key="Detail"]}[Data]
in
    Detail

     

    I was also able to create a new connection using AzureConsumptionInsights and selected UsageDetails.

     

     

    let
     Source = MicrosoftAzureConsumptionInsights.Tables(??EnrNo??, []),
     usagedetails = Source{[Key="usagedetails"]}[Data]
    in
     usagedetails

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.!

     

  • nagarjunakan's avatar
    nagarjunakan
    Helper I
    6 years ago

    Hi @Allan77R2V1,

    Please share that Microsoft Azure consumption insights pbit file 

     

    Thanks in advance!

    Regards,
    Naga

  • nagarjunakan's avatar
    nagarjunakan
    Helper I
    6 years ago

    Hi Allan77R2V1,

    Please share that Microsoft Azure consumption insights pbit file

     

    Thanks in advance!

     

    regards 

    Naga