Forum Discussion
Usage Reports
Hi community,
In my company we have more than one workspace for example:
Finance
Hr
Sales
Operations
Each workspace has reports that use the same semantic model
I would like to know if its possible to know the reports usage between workspaces, meaning, i want to know from all the reports in all workspaces, which reports are more used. is it possible?
Hi, at my workplace BI platform team uses 'Power BI Audit Logs' and they created one semantic model that we can use to query the report usages across workspaces. This will also give all reports' historical usage data instead of just 3 month/1 month past usages by default.
For enabling audit logs, it would be same as in your company. You might need to reach out to BI/IT Admins and request them to do this through MS 365.
Hope it helps:)
10 Replies
- collinq
Super User
HI liligs ,
There are some items in Github that some folks have built. If you want to do it yourself, there are the Rest API's. Those can be found here:
Reports - REST API (Power BI Power BI REST APIs) | Microsoft LearnThe Get Activity Events is probably the one to try first.
- MasonMA
Hi, at my workplace BI platform team uses 'Power BI Audit Logs' and they created one semantic model that we can use to query the report usages across workspaces. This will also give all reports' historical usage data instead of just 3 month/1 month past usages by default.
For enabling audit logs, it would be same as in your company. You might need to reach out to BI/IT Admins and request them to do this through MS 365.
Hope it helps:)
Hi MasonMA could you advise a little bit on it , how can we do it as microsoft techincal support said we cant get data for more than 30 days but our requirement is of more than 6 months like 1 year etc
- MasonMA
Hi liligs and zainqazi96
You can refer to
https://learn.microsoft.com/en-us/fabric/admin/service-admin-portal-audit-usage
Also the retention policy herehttps://learn.microsoft.com/en-us/purview/audit-log-retention-policies
For both of our cases, a curated solution combining audit logs plus metadata for long-term analysis would need to be created by IT.
v-tejramaCommunity Support
Hi liligs ,
Has your issue been resolved?If the response provided by collinq and MasonMA addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.
Thank you for your understanding!Hi i'm still testing because i dont have admin access to audit logs
- HarishKM
liligs Hey,
Yes, it's possible to track report usage across different workspaces in Power BI using the Power BI Admin Portal and Activity Log:
If you have admin rights, access the Power BI Admin Portal to view usage metrics and activities across all workspaces.
Use the Power BI activity log to export data on report usage, which includes details on views and interactions. This will give insights into which reports are more frequently used across different workspaces.
- You can configure usgae metric in all workspace and then export that in excel from all workspace in a sharepoint folder.
- append all data in a excel file.
- Create a custom dashboard within Power BI utilizing the exported activity log data to visualize and analyze report usage trends.
Thanks
Harish KM
If these steps help resolve your issue, your acknowledgment would be greatly appreciated.
