Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

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.

Helpful resources

Announcements
ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.