topic Re: Generating an access token in Developer

Generating an access token

dpm — Fri, 22 Jan 2021 17:51:02 GMT

I am generating an access token to use with the Power BI REST API but for users with MFA enabled that doesn't work.

Request: https://login.microsoftonline.com/common/oauth2/token
client_id: ...
grant_type: password
resource: https://analysis.windows.net/powerbi/api
username: ...
password: ...
client_secret: ...

Error message:
AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access

Is there any way to obtain the access token without disabling MFA?

Thank you in advance!

Re: Generating an access token

lbendlin — Sat, 23 Jan 2021 14:52:04 GMT

There are a couple of posts in this forum on that topic.

https://community.powerbi.com/t5/Developer/Power-BI-Admin-API-with-MFA/td-p/1117389

https://community.powerbi.com/t5/Developer/Bypassing-MFA-to-automate-data-refreshing-using-REST-API/td-p/516014

Re: Generating an access token

dpm — Sun, 24 Jan 2021 19:34:35 GMT

Thank you Ilbendlin,

Disabling MFA is not an option unfortunately. I read answers from the second post but from what I can see SPN can't be used to obtain the access token needed. I've seen other applications offering the same functionality using the API and it was compatible for users with MFA enabled. Is it maybe possible to use the 'client_credentials' grant type for obtaining the access token somehow?

Thank you in advance.

Re: Generating an access token

dpm — Tue, 26 Jan 2021 19:28:48 GMT

If someone has come across this and the solution for this, I highly appreciated. Thanks for contributing ideas.

Re: Generating an access token

WouterV — Thu, 09 Dec 2021 14:23:13 GMT

through Powershell it can be done, have a look at module MicrosoftPowerBIMgmt