Microsoft Azure Consumption Insights API

[Allan77R2V1]

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?

[Syndicate_Admin]

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

[Allan77R2V1]

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

[Syndicate_Admin]

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

[Allan77R2V1]

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.

[Syndicate_Admin · Accepted solution]

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