Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good day,
One of my projects is to create a Usage metric report in Power BI. We are talking about around 60 workspaces.
The idea is to have a more comprehensive report versus on pre-built usage metrics in power bi. and publish just like a normal report in Power BI Service..
Luckily I was able to see some resources online.
(2) Automate Power BI Usage data across workspaces using Paginated Reports | LinkedIn
Build Your Own Power BI Audit Log; Usage Metrics Across the Entire Tenant - RADACAD
Probably tied up into an employee table so we can see the heirachy per program/dept about their usage of the report in each workspace. Do I need to have admin/tenant access to do that? What else do I need to consider when making such a report,
Anyone who was able to do it before. Would be great and possibly resources on the web to start with..
Thank you so much
Solved! Go to Solution.
You need two things
1. Somebody needs to have initiated Usage Metrics for the report(s)
2. you need to be a member of the workspace(s) holding the usage metrics dataset(s)
3. you need to keep in mind that usage metrics datasets and their reports will disappear if nobody looks at these reports for a certain period of time. Means you need a process to keep these alive.
Then all that's left is to modify the report template so it connects to multiple datasets.
For a larger organization this process becomes very ugly very quickly. What we do instead is offer report usage information based on the tenant audit logs. It doesn't have page level usage details, but it keeps history for much longer and doesn't require any keep-alive acrobatics.
You need two things
1. Somebody needs to have initiated Usage Metrics for the report(s)
2. you need to be a member of the workspace(s) holding the usage metrics dataset(s)
3. you need to keep in mind that usage metrics datasets and their reports will disappear if nobody looks at these reports for a certain period of time. Means you need a process to keep these alive.
Then all that's left is to modify the report template so it connects to multiple datasets.
For a larger organization this process becomes very ugly very quickly. What we do instead is offer report usage information based on the tenant audit logs. It doesn't have page level usage details, but it keeps history for much longer and doesn't require any keep-alive acrobatics.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |