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.