March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Did anyone figure out how to capture Power BI Tenant growth over time at your company? We're trying to see some key metrics like Active users, number of workspaces, artifacts over time in a visual to show the exponential growth we've had in last 5years.
Thanks!
-Pawan
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
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.
User | Count |
---|---|
25 | |
21 | |
11 | |
10 | |
9 |
User | Count |
---|---|
48 | |
30 | |
18 | |
17 | |
15 |