Power BI Report Usage Metrics not given fresh data usage.

[PoojaPal]

I need to run the usage data of all the reports that our in all the workspaces. To get the views, users and data source usage for last 6 months. 

[rohit1991]

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.

[v-venuppu]

Hi @PoojaPal ,

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?

Thank you.

[V-yubandi-msft]

Hi @PoojaPal ,

I hope my message clarified everything. If everything is resolved, please mark it as Accepted solution. Please let me know if you are facing any issues.

Thank You.

[V-yubandi-msft]

Hi @PoojaPal ,

Does the solution provided address your issue, or are you still experiencing the problem? Your feedback is important to the community. If your issue has been resolved, please mark the response as Accepted Solution to help others find it more easily.

Thank you.

[V-yubandi-msft]

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.

[Nasif_Azam]

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

[BhavinVyas3003]

Hi @PoojaPal ,

If you're using Power BI Pro, you're limited to 8 refreshes per dataset per day, including those triggered via Power Automate, which is why you're seeing the “operation throttled” error.

If you're on Premium or Fabric capacity, Power Automate refreshes are not limited in count, but can still be throttled if capacity is overloaded or too many refreshes run concurrently.

To avoid throttling, space out your flows and monitor capacity usage if on Premium.