M Query/ KQL Query to call Multiple Azure Subscriptions

[Sudharshan1919]

Hello Everyone,

I am having nearly 10 Azure Subscriptions. I need to call all of those subscriptions and the respective data using APIs or KQL Query (Log Analytics Query, but not Azure Resource Graph). I need to get all of those data in one table and need to show them in Visualization part.

Example:

Subscriptipon1 -- API1 -- 10 VMs

Subscription2 -- API2 -- 20VMs

Subscription3 -- API3 -- 30VMs   ---> Total : 60VMs.

I need solution for this, either with M Query or with KQL Query.

Kindly help me on this.

Thanks,

Sudharshan

Power BI Mquery

[Sudharshan1919]

Hey @Eyelyn9 ,

The solution which you have sent is inappropriate for my requirement. My requirement is as below.

Total Azure Subscriptions: 10.. that means i need to form 10 Azure APIs...

Each subscription is having 10VMs each... and the count is "10 Subscription * 10 VMs each" = 100 VMs count i need to get.

This should be achieved by Power BI M Query method. If it is possible through Looping in Power BI M query, please provide the required reference links.

Kindly suggest or guide me through this Process, so that my requirement will be satisfied.

Thanks,

Sudharshan

[Eyelyn9]

Hi @Sudharshan1919 ,

Hope these could help:

https://docs.microsoft.com/en-us/rest/api/power-bi-workspace-collections/workspace-collections/list-...

https://community.powerbi.com/t5/Desktop/Error-calling-rest-api-manangement-azure-com-from-powerbi-c...

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.