Forum Discussion

Brahms99's avatar
Brahms99
Frequent Visitor
2 months ago
Solved

Store PowerBi Workspace Data Usage Metrics for More than 30 Days

Hello,    I want to build the power bi usage metrics on my power bi desktop since the user metrics on Power bi service are limited to 30 days. I need the show the page views, unique viewers, report...
Need Help
Show and Tell
Tutorial Requests
  • Brahms99's avatar
    Brahms99
    1 month ago

    Hi v-sathmakuri 

    I was able to find another solution to resolved. Thank you 

Brahms99's avatar
Brahms99
Frequent Visitor
2 months ago

Thank you. How do you find/use the the Power BI REST API?

v-kpoloju-msft's avatar
v-kpoloju-msft
Icon for Community Support rankCommunity Support
2 months ago

Hi Brahms99, 
Thank you for reaching out to the Microsoft Fabric Community Forum.

You can find the Power BI REST API documentation here: Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn. For collecting report usage and activity, Admin - Get Activity Events - REST API (Power BI Power BI REST APIs) | Microsoft Learn is the relevant endpoint. Please note that this is an Admin API, so you will need Power BI/Fabric administrator permissions (or assistance from your administrator) to access it.

You can schedule the API to run daily using PowerShell or Power Automate, then store the results in SQL Server, SharePoint, Excel, or CSV files. From there, connect Power BI Desktop to the stored data to build your own historical usage report beyond the built-in retention period, no Lakehouse is required. Access the Power BI activity log - Power BI | Microsoft Learn article provides step-by-step examples for retrieving activity events, and Track user activities in Power BI - Microsoft Fabric | Microsoft Learnexplains how to export activity events and build custom usage reports.

Hope this helps. If you have any questions regarding this, please feel free to reach out us. We will be happy to help.