cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

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

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
Highlighted
Community Support
Community Support

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

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.
Highlighted
Regular Visitor

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

 

Highlighted
Community Support
Community Support

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

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.
Highlighted
Regular Visitor

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.

Highlighted
Community Support
Community Support

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (6,716)