Automatically export usage metrics of report

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 

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.

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. 

Check this out: 

https://powerbi.microsoft.com/en-us/blog/the-power-bi-activity-log-makes-it-easy-to-download-activity-data-for-custom-usage-reporting/

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.