Combining Usage Metrics Reports from Multiple Workspaces into One

[LuigiBros]

Hi everyone,

I have a question regarding the Usage Metrics Report.
Currently, I'm using separate reports for each of my 10 workspaces, but I'd like to consolidate all the data into a single comprehensive report in Power BI.

Has anyone tackled this before? Are there any tools, techniques, or best practices that you could recommend to merge these individual reports into one?
Any guidance or examples of how this can be achieved would be greatly appreciated.

Thanks in advance for your help!

[ibarrau · Accepted solution]

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

[LuigiBros]

@ibarrau @v-tsaipranay 

I was able to configure and create everything in Power BI Desktop, including an automatically refreshable access token, and it works flawlessly in PBI Desktop.

However, when I publish it to the Service, it stops refreshing after some time (probably when the token expires).

Do you have any solutions for this?

[v-tsaipranay · Accepted solution]

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. 

[v-tsaipranay]

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.

[v-tsaipranay]

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. 

[v-tsaipranay]

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.

[v-tsaipranay]

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.

[v-tsaipranay]

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.

[LuigiBros]

Do you know if there are any tutorials on how to build it using REST API?
YouTube or blog?

I found some but they are quite old (3-4 years) and already a bit outdated.

[ibarrau · Accepted solution]

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

[ibarrau]

Hi. Nowadays there is a "Admin Workspace" that users with Fabric Administrators role can see. That workspace contains a report "Feature usage and adoption". That report contains usage metrics of the whole organization. You can see it all for the last 30 days. https://learn.microsoft.com/en-us/fabric/admin/feature-usage-adoption

That should be the simplest solution.

In Addition, if you are looking for a custom development building a history of usage. You can integrate data in a storage using Power Bi Rest API to get the activity logs: https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events

I hope that helps,

[LuigiBros]

"Feature usage and adoption" from "Admin Workspace" has one big disadvantage.
When user opens report via OrganizationalApp then I do not see which report was actually opened.