topic Re: How to disable multi factor authentication to use POwer BI REST API in Developer

How to disable multi factor authentication to use POwer BI REST API

Anonymous — Sat, 06 Oct 2018 15:24:24 GMT

Hi,

I am running a powershell script to get the refresh history of all pbi reports of respective workspaces.

Problem: I need to run the script manually, I mention here manually because whenever I run the script it ask me to validate my Microsoft account by entering the pin code (multi-factor authentication). Due to this I am not able to automate the script. I don’t know if it is possible to get authentication token without validating the account or to disable multi-factor authentication. Any suggestion would be really helpful.

Below is the code to Get authentication token:

$clientId = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxx"

# Calls the Active Directory Authentication Library (ADAL) to authenticate against AAD

function GetAuthToken

{

$adal = "${env:ProgramFiles}\WindowsPowerShell\Modules\AzureRM.profile\5.3.2\Microsoft.IdentityModel.Clients.ActiveDirectory.dll"

$adalforms = "${env:ProgramFiles}\WindowsPowerShell\Modules\AzureRM.profile\5.3.2\Microsoft.IdentityModel.Clients.ActiveDirectory.WindowsForms.dll"

[System.Reflection.Assembly]::LoadFrom($adal) | Out-Null

[System.Reflection.Assembly]::LoadFrom($adalforms) | Out-Null

$redirectUri = "https://oauth.powerbi.com/PBIAPIExplorer"

$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

Thanks in advanced

Re: How to disable multi factor authentication to use POwer BI REST API

piper — Tue, 12 May 2020 16:34:54 GMT

Had you succeeded in disabling multi factor authentication for power bi rest api?

Re: How to disable multi factor authentication to use POwer BI REST API

Anonymous — Tue, 12 May 2020 17:46:22 GMT

@piper,

Thank you for reply, unfortunately no.

Re: How to disable multi factor authentication to use POwer BI REST API

piper — Tue, 12 May 2020 18:02:03 GMT

I am also stucked with same issue since couple of days.

Can you share what work around you had used to get things working?

Re: How to disable multi factor authentication to use POwer BI REST API

Anonymous — Wed, 13 May 2020 13:07:57 GMT

Have you tried using Service Principal/App Registration via AAD? Make sure you assign PowerBI API Permissions for the registration and then you can get an access token for the registration

Re: How to disable multi factor authentication to use POwer BI REST API

piper — Fri, 15 May 2020 11:20:55 GMT

Thanks for reply.

Yes, I had tried out service principal way earlier, when didn't have powerbi pro account. And, it hadn't work earlier.

Which is why, I had purchase powerBI pro.

I don't recall the actual error now, but somewhere it was related to not able to generate access token.

For now, I got unblocked by disabling multi factor authentication using following:

https://community.powerbi.com/t5/Service/Disabling-multi-factor-authentication-for-power-bi/m-p/1087144/highlight/true#M95752