Forum Discussion
How to retrieve month-wise usage logs across multiple workspaces or capacity in Microsoft Fabric?
- 3 months ago
Hi Anusha66,
The Power BI GetActivityEvents API is what you're after.
This has all logs for everything that happens in Fabric.
I recommend setting up a process that pulls this information daily into a lakehouse or another database.The API only stores 28 days of data, and you can pull at max 24 hours of data at a time.
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events
- 3 months ago
Hi Anusha66,
Hope you're doing well!
Here are direct answers to your 3 questions:
Retrieve usage logs centrally for multiple workspaces? Admin Activity Log API or Unified Audit Log, tenant-wide
Aggregated report-level metrics month-wise? via downstream aggregation in Lakehouse/Notebook or KQL in Log Analytics
Avoid workspace-by-workspace looping? Admin API is tenant-scoped; loop over days not workspaces
Hi Anusha66,
The Power BI GetActivityEvents API is what you're after.
This has all logs for everything that happens in Fabric.
I recommend setting up a process that pulls this information daily into a lakehouse or another database.
The API only stores 28 days of data, and you can pull at max 24 hours of data at a time.
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events