Answered

Microsoft Azure Consumption Insights API

(0) Share

Report

Posted on by Allan77

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?

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (1)

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Allan77 6 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Allan77 6 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No