Reply
pvuppala
Helper IV
Helper IV

Power BI Tenant Usage Adoption History

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

2 REPLIES 2
CoreyDupuis
Regular Visitor

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:

  https://www.fourmoo.com/2020/02/12/how-you-can-store-all-your-power-bi-audit-logs-easily-and-indefin...

 

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

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