Forum Discussion
Power BI Usage Metrics and Access Tracking
Hi Team,
I need your support regarding the usage metrics.
In Power BI Service, the usage metrics currently show only the last 30 days of data, but we would like to view usage for all months. Is there any option in Power BI Service to get usage metrics data for multiple months?
We are using Pro licences.
Thanks and regards,
Suman
Hi Suman250585,
as I have not implemented this approach by my self yet and it also depends on your given system requirements and constraints (e.g. where you can store the logs like SQL DB on-prem/cloud, SharePoint,... and your rights/roles), I just can give you the advice to follow allong the MSFT documentation for it.
Check them out here:
Track user activities in Power BI - Microsoft Fabric | Microsoft Learn
Access the Power BI activity log - Power BI | Microsoft Learn
Video from RADACAD:
Export Power BI Audit log in a few Simple Steps with No Code
Best regards!
PS: If you find this post helpful consider leaving kudos or mark it as solution
6 Replies
- cengizhanarslan
Super User
No, the built-in Usage Metrics report in Power BI Service cannot show more than 30 days. That limit is by design and cannot be extended, regardless of Pro or Premium.
Alternative 1) Use the Power BI REST API
Microsoft’s Activity Events / Admin APIs allow you to collect report views, dashboard views, dataset refreshes, user, workspace, timestamp. You canp ull data daily, store it (SQL, SharePoint, Fabric, etc.), build a custom usage model with unlimited history.
Alternative 2) FUAM (Fabric Unified Audit Model)
FUAM is Microsoft’s new unified audit and activity model for Power BI and Fabric. UAM exposes detailed user and artifact activity events (report views, dataset usage, refreshes, etc.)
- Mauro89
Super User
Hi Suman250585,
there exists another post regarding this topic here Solved: Usage Metrics - how to get more than 30 days of da... - Microsoft Fabric Community.
Recap, with this report it is not possible to get more than 30 days.
One workaround I could imagine considering PBI Pro license as a constraint is to manually export monthly data and put them as historical data into a semantic model. More advanced with potential for automation would be to use activitiy log API.
If you have access to Fabric and a capacity I recommend using the FUAM app.
Best regards!
PS: If you find this post helpful consider leaving kudos or mark it as solution
- Suman250585Regular Visitor
Hi Mauro,
Thanks for sharing the updates.
Could you please suggest how we can implement this workaround with a step‑by‑step procedure, and share any relevant links or documentation to achieve it?
- Mauro89
Super User
Hi Suman250585,
as I have not implemented this approach by my self yet and it also depends on your given system requirements and constraints (e.g. where you can store the logs like SQL DB on-prem/cloud, SharePoint,... and your rights/roles), I just can give you the advice to follow allong the MSFT documentation for it.
Check them out here:
Track user activities in Power BI - Microsoft Fabric | Microsoft Learn
Access the Power BI activity log - Power BI | Microsoft Learn
Video from RADACAD:
Export Power BI Audit log in a few Simple Steps with No Code
Best regards!
PS: If you find this post helpful consider leaving kudos or mark it as solution
- v-achippa
Community Support
Hi Suman250585,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Mauro89 and cengizhanarslan for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa
- v-achippa
Community Support
Hi @Suman250585,
We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa