cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Allan77
Regular Visitor

Microsoft Azure Consumption Insights API

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-yamao-msft
Community Support
Community Support

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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-...

 

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,199)