Connecting PowerBI desktop to Azure Authenticated function

[Muha_imrak]

Hello, 

Is it possible to connect powerbi desktop to azure authenticated function app.

I am trying to connect it to our Azure function and getting this error.

 

I have configured Azure function as mentioned in the below article.

https://www.linkedin.com/pulse/securing-azure-functions-active-directory-kiran-kumar-somisetty/

From browser I am unable to connect, but it is not working for powerbi.

Regards,

Imrak

[narcislascu88]

Did anyone found a solution to this? I have the same issue?

[gwuhm]

Hello,

anyone has some tips to this? I'm in the same situtation, without any luck 😞

I've tried every possible app registration config, (global) permissions granting etc, but still nothing.

Basic "hello world" as azure function, with AAD authentication (easy auth set on function), works fine from browser (after login with MFA)

Thank you

Pavel

[v-yalanwu-msft]

Hi, @Muha_imrak ;

Your account is in the organization, right?
 Organization that I was trying needed to be part of Active directory in order to use its organizational account to pull data. 
According to the error message, If your account is not in a tenant, try creating personal accesstoken to login and pull data.

Enter client credentials in Power BI or Excel 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.