Forum Discussion
Combining Usage Metrics Reports from Multiple Workspaces into One
Well the api has been there for a long time, it would be normal if the videos or blog are not from today. You can get started with the API reading this blog: https://blog.ladataweb.com.ar/post/740398550344728576/seteo-powerbi-rest-api-por-primera-vez
Consider you need code skills in powershell, or like this example shows, python. You could also use another, but those two have material to make it easier with powerbi cmdlets or python simplepbi library.
I hope that helps,
P/D Nice catch that feature and adoption doesn't show the report of the app that's viewed
Hello LuigiBros ,
The issue with token expiration in Power BI Service during scheduled refreshes occurs because the service does not automatically regenerate API tokens. To resolve this, the best approach is to create a custom Power BI connector using Power Query SDK that implements OAuth2 authentication with automatic token refresh capability. This custom connector will securely handle token generation and renewal without manual intervention.
Alternatively, you can use PowerShell, Azure Functions, or Python scripts to automate token refreshes externally and push the data into Power BI using the Power BI REST API. This method ensures seamless data updates while bypassing token expiration issues. Both solutions require proper security configurations and periodic maintenance to ensure consistent performance.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi LuigiBros ,
Thanks for reaching out to the Microsoft fabric community forum.
I would also take a moment to personally thank ibarrau , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
To address the issue of tracking specific reports accessed via an OrganizationalApp, you can use the Power BI REST API to gather more detailed usage data. This API provides a more granular approach to tracking user activity, including identifying which reports were accessed.
We recommend using the Get Activity Events endpoint from the Power BI REST API. This will allow you to collect detailed logs, including:
- The specific reports that were opened and who accessed the report (user details).
- The time and date of access and the type of action performed (e.g., view, interact).
For more information, please refer to the official Admin - Get Activity Events - REST API (Power BI Power BI REST APIs) | Microsoft Learn
To simplify the process of retrieving and managing this activity data, you can use PowerShell or Python. Both of these languages are commonly used to interact with the Power BI REST API, and they offer libraries that make it easier to handle the data.
By implementing this approach, you will overcome the limitations of the built-in Feature usage and adoption report and gain deeper insights into which reports are being accessed, including those opened via an OrganizationalApp.
I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.