Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Microsoft Azure Consumption Insights API

(0) ShareShare
ReportReport
Posted on by 6

Hi,

 

Microsoft has a new Azure Billing API and I want to use Flow to download CSV files and store them on OnDrive. THe url is https://consumption.azure.com/

 

I can connect and pull the data through PowerBI so I know how to connect, I just cant figure out how to do this with Flow. 

 

Has anybody tried or done this?

  • Verified answer
    v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Microsoft Azure Consumption Insights API

    Hi @Allan77,

     

    It is possible to call APIs, services, and systems that aren’t available as prebuilt connectors by creating custom connectors.

    If you are not familiar with custom connector, you can start with the custom connector overview:

    https://docs.microsoft.com/en-us/connectors/custom-connectors/

    Besides, please check the following docs on Custom Connectors in Microsoft Flow for a reference:

    https://docs.microsoft.com/en-us/flow/developer/register-custom-api

    Please take a try with it on your side.

     

    Best regards,

    Mabel

  • Allan77 Profile Picture
    Allan77 6 on at
    Re: Microsoft Azure Consumption Insights API

    Do you think its possible to use a custom connector? I tried to figure this out but couldnt get to a point where it would work. Im not at all familar with the settings for a custom connector so I was guessing at the configuration.

  • v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Microsoft Azure Consumption Insights API

    Hi @Allan77,

     

    Thanks for updating.

    Azure Consumption Insights is now available for Power BI. However, it is not an available connector for Microsoft Flow yet.

    Please check the following doc on flow connectors for more details:

    https://docs.microsoft.com/en-us/connectors/

    If you need this feature, please feel free submit a request on Flow Ideas Forum so that it might be considered in future releases:

    https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

     

    Best regards,

    Mabel

  • Allan77 Profile Picture
    Allan77 6 on at
    Re: Microsoft Azure Consumption Insights API

    Hi Mabel,

     

    Yes that is correct, Microsoft is retiring the older REST API's at the end of Dec so it is definitly widley available. The link below has the details for connecting via PowerBI which does work. I would like to use Flow to download and persist the data on Onedrive versus what Im currently doing which is downloading the entire multi year data set evertime I refresh (nightly) in PowerBI. 

     

    https://docs.microsoft.com/en-ca/power-bi/desktop-connect-azure-consumption-insights#migrating-from-the-azure-enterprise-connector

     

  • v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Microsoft Azure Consumption Insights API

    Hi @Allan77,

     

    Are you trying to connect to Microsoft Azure Consumption Insights from Flow?

    I haven’t seen any related docs on this connector. It seems that it is still not available on my side.

    Could you share more details on it?

     

    Best regards,

    Mabel

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard

Featured topics