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. 

[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.