Forum Discussion
Download Usage metrics
Hi all,
As a Power BI admin, we would like to save our historical usage metrics from PowerBI.com. We want to keep track of the usage of dashboards and reports over time.
We can ofcourse view the metrics (per individual report) or via the admin portal for the total environment, but we're missing the possibility of downloading the corresponding dataset. I've seen the possibility of customizing the default report, but that doesn't make the option to download the statistics.
How can we download (e.g. to Excel) the statistics for local storage?
Thanks!
Greetings,
Henri
Hi TSH
You can not download PBIX of Usage Metrics directly from Power BI Service.
As a workaround, you can connect to power bi service in power bi desktop and select Dashboard Usage Metrics Model or Report Usage Metrics Model you have created.
After being loaded into power bi desktop, you can save the report as a PBIX file.
3 Replies
Hi, sure you can but not directly from Power Bi. You have two ways of doings this.
- Global Office admin: turn on audit logs in power bi admin tenant settings and export it: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing#:~:text=Unified%20audit%20log-,Power%20BI%20activity%20log,as%20global%20admins%20and%20auditors.
- Power Bi admin: use power bi api to get activity events with rest api https://docs.microsoft.com/en-us/rest/api/power-bi/admin/getactivityevents
Hope this helps.
Hi TSH
You can not download PBIX of Usage Metrics directly from Power BI Service.
As a workaround, you can connect to power bi service in power bi desktop and select Dashboard Usage Metrics Model or Report Usage Metrics Model you have created.
After being loaded into power bi desktop, you can save the report as a PBIX file.
When renaming a .pbix I am losing usage metrics (or seeing that the report no longer shows in the report in the service). I am considering creating my own report as a work around. Is there a way around all of this extra work resulting from a simple renaming of a dashboard in the premium service?
