Azure Integration - Resource Types

[MR07]

Hi, 

I am new to PowerBI and am struggling to understand how best to acheive my goal - which I'm hoping you may be able to help with.

I have a number of Azure Subscriptions with many resources. Each resource has a project tag. I want to generate a representation of the resource types in use, the amount of those restource types and the project they are associated to. 

i.e. Project A may have 10 instances of Container App, Project B may have 10 virtual machines. I want to show that graphically - equally, I don't want to account for all resource types. Just specific ones. My idea is to export all of this data from Azure into a CSV, manipulate it and then generate a PowerBI report. Is this the optimum way to achieve this? or si there a connector for this which could help?

And guidance would be appreciated.

TIA

[aj1973]

Hi @MR07 

Your idea is good but it is not automatized/automated.

Yes there are AZURE REST APIs that you can use to retrieve, export, and save data into CSV, JSON formats in a local machine using Powershell(for example)

Get started with the REST APIs for Azure DevOps Services and Azure DevOps Server - Azure DevOps Serv...

Once stored, you can import those files into Power BI to create you report. Note if you store the files in a Local machine then you will need an On-Prem Power BI Gateway.

[MR07]

Thanks Amine, 

I've been searching all over today for some answers and I've actually found a way to sort of achieve what I am after here. But it is not automated at the moment. It is a manual approach. I have found that there is a connector which is in public preview - Azure Resource Graph which gives me the information I am after. I can then do some power BI queries to count the data and give me a visual reresentation.

Azure Resource Graph x Power BI is finally here! - Microsoft Community Hub

I'm going to see if I can automate this approach to make it dynamic.