Forum Discussion
Admin Report
Hello,
I want to create an admin portal on PowerBI desktop of the whole PowerBI enviroment in our enterprise.
But I am stuck with the refresh token as I get a refresh token only 15 mins, how can I have a fixed token to access or to automatically refresh my access token ?
2 Replies
- GilbertQSuper User
Hi MAwwad
From the sounds of it what you need to do is to create a Service Principal which can then access the APIs
Here is a blog post on how to do this in the section highlighted below.Using the Power BI Scanner API to Manage Tenant's Entire Metadata -
- AnonymousNot applicable
Hi MAwwad ,
I have found a similar post, please refer to it to see if it helps you.
Solved: Refresh token api call - Microsoft Power BI Community
-
I stumbled over a similar problem as you last year. I solved my api connection by buidling a custom data connector.
https://github.com/Microsoft/DataConnectors
With the connector you have a lot of possibilitys for authentication handling:
see: https://docs.microsoft.com/en-us/power-query/handlingauthentication
The custom Connector can be attached to the data gatway from there the api calls are made.
- Step one: Create parameters for client_id, client_secret, oauth token, search url, username, password
Step two: a new query with the following
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-