Extract Data from Azure Resources?

Question

Need help on data extraction from azure.
We have a subscription and within that there are multiple resource groups and multiple resources.

I need to extract performance data from all these resources like VM, SQL, Databricks, containers etc. and store it in a blob containers and load it to Power BI.
Unfortunately, i am not getting clues and options on how do i move this to blob [container] for to be used in Power BI.
The usage of these is to monitor the availability of the resources and any downtime/ failure.

Kindly guide

Answer 1

Hello @Shivi Bhatia ,
Thanks for your query !

To extract performance data w.r.t azure resources you can start with the examples mentioned here:
https://learn.microsoft.com/en-us/powershell/module/az.monitor/get-azmetric?view=azps-6.1.0

List of all the supported metrics which can be extracted:
https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/metrics-supported

For instance , to get performance metrics w.r.t Azure Virtual Machines - try to use the below sample script which will pull all the metrics and generate an excel sheet

https://manjunathrao.com/2018/02/22/azure-collecting-performance-metrics-for-azure-virtual-machines/

If you are planning to store the extracted data in a blob , then you can use the PowerBI to connect to azure storage account and present the data in tabular format:

Use the steps mentioned here:- https://powerbidocs.com/2020/10/14/connect-power-bi-to-azure-blob-storage/
(Make a note of Step-10 in the above article)

Let us know if you have additional questions.