Forum Discussion
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 views for an extended period of time that goes beyond 30 days.
I have researched all over but all the tutorials I found are skipping steps on how to do this. Can you point me to a resource that has a step by step on how to do this? Also, I do not have access to Lakehouse (I found a couple tutorial that pointed to that).
Thank you
Hi v-sathmakuri
I was able to find another solution to resolved. Thank you
10 Replies
- parry2k
Super User
Brahms99 have you seen this azure log analytics in Power BI. Using Azure Log Analytics in Power BI - Power BI | Microsoft Learn
Our company uses an O365 API to request out the usage data on a daily basis (Search-UnifiedAuditLog (ExchangePowerShell) | Microsoft Learn). The one thing we don't get is the page views, i'm not sure if they allow it as its quite a lot of data. The output goes to a daily CSV file, which we injest.
- krishnakanth240
Hi Brahms99
We can’t extend Power BI built in usage metrics beyond 30 days. To keep history longer, you can export the data regularly and store it yourself using Power BI REST API or Microsoft 365 audit logs to pull activity events. Automating exports with Power Automate into SQL, SharePoint, or Excel. Then you can build your own report in Power BI Desktop from the stored data
Thank you. How do you find/use the the Power BI REST API?
v-kpoloju-msftCommunity Support
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.
- parry2k
Log analytics on workspace is a way to go
- v-kpoloju-msft
Hi Brahms99,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to parry2k, krishnakanth240, Anonymous, for those inputs on this thread.Has your issue been resolved? If the response provided by the community member parry2k, krishnakanth240, Anonymous, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.- v-kpoloju-msft
Hi Brahms99,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.
- v-sathmakuri
Hi Brahms99 ,
Could you please confirm whether the provided solution helped in resolving the issue. If you have any further questions please feel free to reach out to us.
Thanks!!
Hi v-sathmakuri
I was able to find another solution to resolved. Thank you
