Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

M Query/ KQL Query to call Multiple Azure Subscriptions

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.



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.





Power BI Mquery


Frequent Visitor

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.





Community Support
Community Support

Hi @Sudharshan1919 ,


Hope these could help:



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.

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors