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.
ibarrau Anonymous
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?
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 ,
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.