- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous ,
This is not possible out of the box but you could do this with R or even with this link:
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Im trying to do the same thing. Did you have any luck with this?

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 05-07-2024 02:30 AM | ||
08-02-2024 07:55 AM | |||
11-06-2024 06:39 AM | |||
11-04-2024 04:27 AM | |||
09-16-2024 06:41 AM |
User | Count |
---|---|
47 | |
31 | |
30 | |
26 | |
25 |
User | Count |
---|---|
47 | |
33 | |
19 | |
18 | |
16 |