Admin Report

[MAwwad]

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 ?

[v-rongtiep-msft]

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.

[GilbertQ]

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 -