Forum Discussion
Retaining data from Power BI Usage Metrics monthly
Hi mjoseph111,
There’s no public API that exposes the same dataset used by the built‑in Power BI Usage Metrics report. Microsoft doesn’t provide a supported endpoint to directly query that curated usage metrics data.
there are two supported alternatives: you can use the Admin Activity Events REST API to retrieve audit‑level usage events (such as report views and exports), or you can copy and customize the built‑in Usage Metrics report by connecting to its underlying semantic model and building your own report on top of it. Please refer to below docs and let me know if these help?
Track user activities in Power BI - Microsoft Fabric | Microsoft Learn
Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
Monitor report usage metrics - Power BI | Microsoft Learn
Thanks,
Prashanth
Hi mjoseph111,
There’s no public API that exposes the same dataset used by the built‑in Power BI Usage Metrics report. Microsoft doesn’t provide a supported endpoint to directly query that curated usage metrics data.
there are two supported alternatives: you can use the Admin Activity Events REST API to retrieve audit‑level usage events (such as report views and exports), or you can copy and customize the built‑in Usage Metrics report by connecting to its underlying semantic model and building your own report on top of it. Please refer to below docs and let me know if these help?
Track user activities in Power BI - Microsoft Fabric | Microsoft Learn
Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
Monitor report usage metrics - Power BI | Microsoft Learn
Thanks,
Prashanth
v-prasare Thanks for your response. I’m exploring the option of connecting directly to the underlying semantic model and building my own report on top of it. I also need rolling historical data, so I’m planning to persist the usage metrics into SQL for longer‑term analysis.
If you happen to know any best practices or considerations for storing and refreshing that data over time, I’d appreciate any pointers. Thanks again for your help.
