cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sudharshan1919
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.

 

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

 

2 REPLIES 2
Sudharshan1919
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.

 

 

Thanks,

Sudharshan

Eyelyn9
Community Support
Community Support

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.

Helpful resources

Announcements
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