question

ShiviBhatia-7737 avatar image
0 Votes"
ShiviBhatia-7737 asked SumanthMarigowda-MSFT commented

Extract Data from Azure Resources?

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

azure-monitorazure-blob-storageazure-container-instances
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

shivapatpi-MSFT avatar image
0 Votes"
shivapatpi-MSFT answered SumanthMarigowda-MSFT commented

Hello @ShiviBhatia-7737 ,
Thanks for your query !

To extract performance data w.r.t azure resources you can start with the examples mentioned here:
https://docs.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://docs.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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.