topic Re: How to use the Power Bi Rest Api without the refreshtoken? in Developer

How to use the Power Bi Rest Api without the refreshtoken?

KEMKEM — Sat, 03 Feb 2024 23:33:53 GMT

I have a powershell script which is using the Power Bi Rest Api. For the authentication they use some strange solution. They capture the refresh token from the browser and save it in a txt file. Than there is some algoritme which gets a token by the refresh token in the txt file. I dont like this ugly solution.

How can I use the Power Bi Rest Api without this ugly refreshtoken solution? I would like to run this script in an Azure function.

I would for example run this rest api:

https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows/{dataflowId}/transactions

Re: How to use the Power Bi Rest Api without the refreshtoken?

lbendlin — Sun, 04 Feb 2024 01:51:15 GMT

Ask for a bog standard auth token each time before your API call. You need to have an app registered with the required scope, client secret etc.

Re: How to use the Power Bi Rest Api without the refreshtoken?

KEMKEM — Mon, 05 Feb 2024 08:23:19 GMT

Hi @lbendlin Do you have more info? Maybe some link to a tutorial or blog? Or some code snipped?

Re: How to use the Power Bi Rest Api without the refreshtoken?

lbendlin — Mon, 05 Feb 2024 12:47:18 GMT

for example

# Calls the Active Directory Authentication Library (ADAL) to authenticate against AAD function GetAuthToken { if(-not (Get-Module AzureRm.Profile)) { Import-Module AzureRm.Profile } $clientId = "xxx" $redirectUri = "urn:ietf:wg:oauth:2.0:oob" $resourceAppIdURI = "https://analysis.windows.net/powerbi/api" $authority = "https://login.microsoftonline.com/common/oauth2/authorize"; $authContext = New-Object "Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext" -ArgumentList $authority $authResult = $authContext.AcquireToken($resourceAppIdURI, $clientId, $redirectUri, "Auto") return $authResult } # Get the auth token from AAD $token = GetAuthToken

Re: How to use the Power Bi Rest Api without the refreshtoken?

KEMKEM — Mon, 05 Feb 2024 12:58:38 GMT

I dont understand what you mean. Please share some documentation or code snipped.

Re: How to use the Power Bi Rest Api without the refreshtoken?

lbendlin — Mon, 05 Feb 2024 13:14:38 GMT

The code I posted will allow you to receive an auth token without any interaction, as often as needed (I call it before each REST API call). No need for a refresh token. Efficiency be damned.