Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hey @v-eqin-msft ,
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.