unable to source data from web api secured by azure ad (oauth2)

[tejakpa]

Hi,
Does Power BI support a web api data source that is secured by Azure AD authentication(oauth2)? I've tried many ways but it doesnt seem to work. I get authentication error(user not authorized) after trying to login through org. login. I am expecting a org. login page.

[v-yuezhe-msft]

Hi @tejakpa,

Do you want to connect to your Web data source using Azure AD authentication from Power BI? If so, I am afraid it is impossible.

As indicated in this Book Online article, tools like BI and Excel don’t support Azure Active Directory authentication. Moreover, a similar idea about using Azure Active Directory Authentication in Power BI has been submitted in the following link, you can vote it up and add your comments.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10172688-sql-azure-connector-with...

Thanks,
Lydia Zhang