Reply
avatar user
Anonymous
Not applicable

Automatically export usage metrics of report

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

7 REPLIES 7
natalieanderson
Regular Visitor

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
Frequent Visitor
V-pazhen-msft
Community Support
Community Support

@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.

avatar user
Anonymous
Not applicable

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
Super User
Super User

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!



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




avatar user
Anonymous
Not applicable

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

Hi

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

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)