Power BI Report Usage Metrics not given fresh data usage.

Hey PoojaPal ,

To get accurate and up-to-date usage data for all reports across all workspaces over the last 6 months including views, users, and data source usage I recommend the following approach:

Use the Power BI Admin API or Microsoft Graph API: This provides more control and fresher data across tenants.

Leverage the Power BI Activity Log: Export the activity log using PowerShell or set up a pipeline to ingest it into a central dataset. This gives precise insight into: Who viewed which report, When it was viewed, and Workspace and report names.

For data source usage: Consider enabling Azure Monitor for Power BI or checking dataset refresh logs and lineage view.

For Detailed Information:

Power BI Activity Log overview (Microsoft Docs)

Power BI REST APIs - Admin (Microsoft Docs)

Export Power BI activity events using PowerShell (Microsoft Docs)

Lineage view in Power BI (Microsoft Docs)

Monitor usage metrics in Power BI (Microsoft Docs)

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam

Hi PoojaPal ,

Thank you for your question and for participating in the community.

In addition to Nasif_Azam ,  solution, if you are interested in tracking activity across your tenant such as who viewed specific reports and when.  I suggest utilizing the Get Activity Events endpoint in the Power BI Admin API. This tool provides comprehensive audit logs for reports, workspaces, and users.

Please note that the API retrieves data one day at a time, requiring both StartDateTime and EndDateTime to be set within the same UTC day. For multi month data collection, automating the process to iterate through each day will be necessary.

FYI:

Helpful Refrence:

Admin - Get Activity Events - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Thank you for your valuable contributions to the community Nasif_Azam , BhavinVyas3003 .

I hope this helps..

— Yugandhar
Community Support Team.

Hi PoojaPal 

If you need to analyze report usage including views, users, and data source usage for all reports across all workspaces in the last six months, there are a few important points to keep in mind:

• The default “Usage Metrics” report available in Power BI often only shows data from the last 90 days and can sometimes be delayed or not fully up-to-date, especially in large tenants.

• To get more granular and longer-term data, it’s recommended to use the Power BI Activity Log or the Office 365 Audit Log, which can be accessed via the Power BI Admin Portal or with PowerShell scripts. These logs allow you to extract activity details such as who viewed which report, when, and in which workspace.

• For data source usage, you may need to review dataset refresh histories or use the Power BI REST API to get more detailed metadata on dataset connections and usage patterns.

• If you need this usage information regularly, you can automate extraction and reporting by scheduling PowerShell scripts or using tools like Microsoft Purview or third-party monitoring solutions. Note that extracting usage for all workspaces requires Power BI admin rights.