Forum Discussion
How to get Power BI Usage across Multiple workspaces using Lakehouse as source
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
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,
do you know if it will pick data sources and usage for lakehouses etc?
