Forum Discussion
How to get Power BI Usage across Multiple workspaces using Lakehouse as source
anyway to easily pull usage metrics? The built in admin does not provide report level detail only high level workspace for app users
App view not report since its end users
| Workspace 1 | Report X | 10 views |
| Workspace 1 | Report Z | 1003 views |
| Workspace 2 | Report A | 29 views |
| workspace 2 | report b | 1 view |
Hi powerbihelp87,
Thanks for reaching out to the Microsoft Fabric Community forum.According to my understanding and according to Microsoft documentation, the Power BI Admin and Activity Events REST APIs are limited to Power BI artifacts and capture usage only for reports, dashboards, datasets (semantic models), dataflows, and Power BI apps, including app consumption. These APIs do not capture Microsoft Fabric workload telemetry such as Lakehouse, Warehouse, Notebook, or Pipeline usage.
Even when a Power BI report is built on top of a Lakehouse, the APIs record only the report‑level activity and do not expose any underlying Lakehouse table reads or queries. Microsoft tracks Fabric workload usage separately through Fabric‑specific tools such as the Fabric Monitoring Hub and Fabric Capacity Metrics.
In practice, Power BI Admin or Activity Events APIs should be used for report‑ and app‑level usage across workspaces, while Fabric Monitoring and Capacity Metrics should be used for Lakehouse, Warehouse, Notebook, and Pipeline usage. Currently, there is no single API that combines both Power BI usage and Fabric workload telemetry.
For your reference:
https://learn.microsoft.com/en-us/rest/api/power-bi/admin
https://learn.microsoft.com/en-us/power-bi/guidance/admin-activity-log
https://learn.microsoft.com/en-us/fabric/admin/monitoring-hub
https://learn.microsoft.com/en-us/fabric/enterprise/metrics-appI hope this information helps. Please do let us know if you have any further queries.
Thank you
7 Replies
Hi. As a Fabric admin there is a workspace called "Admin workspace" that contains a "Feature and Adoption" report. That report contains all operations in the last 30 days for the whole tenant. That is the easiest way. The other alternative is using the power bi rest admin api to get the data and build a historic data by yourself and create a report as you wish.
I hope that helps,
it doesnt show report detail by apps is my issue, do i need to app registration for the api calls? I dont think they include lakehouse
Hi. If you can't find what you need filtering that, you can go with the api. Yes you need app registration and a fabric tenant settings option of allowing a service principal to use admin api. You can get started reading this article:
https://blog.ladataweb.com.ar/post/740398550344728576/seteo-powerbi-rest-api-por-primera-vezOnce that's done, we use a python library that makes it easy. With a few lines you have it ready to go
https://github.com/ladataweb/SimplePBI/blob/main/Admin_complex.md#get-activity-events
I'll review that admin report to check if I find a an easy path to what you are looking for specifically
I hope that helps,
Hi powerbihelp87,
Thank you for posting your query in the Microsoft Fabric Community Forum, and also thanks to ibarrau for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
Hi powerbihelp87,
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you for being part of the Microsoft Fabric Community.
