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.
Hi LuigiBros ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hello LuigiBros ,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
Hi LuigiBros ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.