Import Power BI Usage Analytics Data to Azure SQL Database

[Anonymous]

Is there any way to gain access to the data source that stores Power BI Report Usage Metrics?

I have tried the "Save As" method here to gain access to the data set, but I would like to pull that data into an Azure SQL database.

Any ideas?

[v-juanli-msft]

Hi @Anonymous 

If you want to analyze Power BI Report Usage Metrics with Power BI, "Save as" is a good method as said below.

"Use Save as to convert the usage metrics report to a full-featured Power BI report that can be customized and shared. Once you’ve created a personalized copy, you’ll get full access to the underlying dataset, allowing you to customize the usage metrics report to your specific needs. You can even use Power BI Desktop to build custom usage metrics reports using the live connection to Power BI service feature."

If you need to analyze it with other tools, you could check the reference below.

EXTENDING THE POWER BI USAGE METRICS TEMPLATE

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.