Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

AAD Authentication with JSON WebAPI consumed by Power BI

I've written my own web service in ASP.NET Core 2 that authenticates against AzureAD and provides a JSON endpoint which I'm trying to consume in Power BI. When I set authentication to Organizational Account and click sign in, I get the following error:

We were unable to connect because this credential type isn’t supported for this resource. Please choose another credential type.

Is there something I need to change in my service so that it will work correctly with Power BI?

like image 529
tonjohn Avatar asked Oct 17 '22 00:10

tonjohn


1 Answers

According to this, AAD auth is not supported:

I am afraid that the AAD authentication type is not supported in Power BI Desktop, please vote up the following ideas.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31405525-support-azure-active-dir...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15039609-active-directory-authent...

Regards, Lydia

I ended up using auth tokens to get around this unfortunate limitation.

like image 69
tonjohn Avatar answered Oct 21 '22 04:10

tonjohn