Forum Discussion
Power BI Tenant Usage Adoption History
Yes! But it's not a simple built-in feature.
We setup a scheduled PowerShell script that pulls the PowerBI Activity logs nightly. You can either drop that into a database or just build a semantic model based on the .csv files.
Here's a few gotchas to watch out for:
1. When running Get-PowerBIActivityEvent the StartDateTime and EndDateTime must be in the same day.
2. Audit logs are retained for a default 90 days.
3. All dates are in UTC when providing parameters or reading data back
4. You'll need admin privilages to retrieve the logs
Here's an excellent post we used as a starting point for the script:
This builds on the provided:
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-auditing
Then you can use your favorite reporting visuals to filter down and display all sorts of events. We like to monitor new reports for engagement and identify top report builders every quarter.
Going back five years will need some other method. Perhaps you could use the PowerBI metadata to search workspaces and try and determine when reports were built. I'm not aware of any way to determine report usage beyond the 90 days though.
Here's another post with additional ideas:
https://community.fabric.microsoft.com/t5/Service/Power-BI-metadata-reporting/m-p/3440571
Have fun!
Corey
- pvuppala2 years ago
Helper V
Hi Corey,
Thank you for your response. We used Audit log APIs in the past to track and monitor user activities and save it in a SQL Table for a long time but, our IT has some sort of Splunk integration so let me check with them. I was really hoping the "Admin Monitoring" workspace would have some insights but, it only goes back 30days.