Automatically export usage metrics of report

[Anonymous]

Hi all,

For auditing reasons we have to export the PowerBI usage metrics of certain reports each month. We are wondering if it would be possible to automate this export process to Excel in a specified folder? 

Kind regards

[natalieanderson]

We have processes running daily that use the Datasets - Execute Queries In Group - REST API to run queries against the Usage Datasets and extract the new data in the datasets. It works really well, but its still unfortunate there isn't a more basic way to get this data. If you want to experiment with it there is a connector in Power Automate for this API call. 

   

[MKinsight]

Check this out: 

https://powerbi.microsoft.com/en-us/blog/the-power-bi-activity-log-makes-it-easy-to-download-activit...

[V-pazhen-msft]

@Anonymous 

Current power bi not contains any functionality to automatically export usage metrics. You can manually export these records by power bi export feature or submit an idea for this requirement.

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

[Anonymous]

Hi @Tomster,

I have not ever tried this but this should work

1. Download usage meteics report (. Pbix) from service to your local machine and republish it again to your workspace, check below url. 

https://www.kasperonbi.com/build-your-own-usage-report-with-power-bi/

2. Republish it again in your workspace and usinh subscription option send the email to yourself and your collegues for this report. 

[collinq]

Hi @Anonymous ,

This is not possible out of the box but you could do this with R or even with this link:

https://www.biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-and-dax-studio-methods/

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[Anonymous]

That link will not work as when you are using Usage Metrics Dataset the Data Tab will not be visible only Model and Visual. 

You will not have an option of Transforming the data.

I am still looking for a solution to automatically export the data from Usage Metrics Dataset

[RootOfMinusOne]

Hi

Im trying to do the same thing. Did you have any luck with this?