Is is possible to connect to and consume an AAD authenticated Azure Functions from Power Bi?

[o365spo]

We've been trying to connect to AAD authenticated Azure function but we get this error.

Reading this might be a limitation of AAD?  Any chance MSFT is working on this?

"The WWW-Authenticate header doesn't contain a valid authorization URI. Header value: 'Bearer realm="XYZ.azurewebsites.net"

[v-qiuyu-msft]

Hi @o365spo,

I got this information: 

In order to consume such authentication, the website must implement something:

https://docs.microsoft.com/en-us/azure/app-service/app-service-mobile-how-to-configure-active-direct...

Please make sure you have implemented this section. If issue persists, please run the Fiddler with below option tabled then repeat steps to reproduce the issue in Power BI desktop, save all sessions and share .saz file with us. You cam upload this file to your OneDrive or Dropbox and share link here. 

Best Regards,
Qiuyun Yu

[o365spo]

Thank you.  Sorry, are you saying we must have a web layer and will not be able to consume the Azure Function (from an Azure Functions App) directly?  We are wondering the same thing about PowerApps and Flow.  Thanks.

[v-qiuyu-msft]

Hi @o365spo,

I'm told by PG team that let you follow the document in my original post. 

For this issue, you can verify this section firstly. And you can capture .saz file as suggested in my original post, and share it with me, I will send this to PG and diagnose this issue. 

Best Regards,
Qiuyun Yu

[v-qiuyu-msft]

Hi @o365spo,

I have sent a email to confirm if there is any update of this issue. Will update here once I get any information. 

Best Regards,
Qiuyun Yu