Web Content - Access Method - WWW-Authenticate header doesn't contain a valid authorization URI

[timowille]

Hi,

i'm trying to connect to a custom REST service hosted on an azure app service that is configured to authenticate against Azure Active Directory. The authentication is working fine, when i open the apis url from a browser.

When trying to connect via Power BI :

I get the following message when i try to authenticate using an organizational account: The WWW-Authenticate header doesn't contain a valid authorization URI. Header value: 'Bearer realm="XYZ.azurewebsites.net"'.

Has anyone managed to authenticate against Azure AD using Power BI for querying data from a Web Api?

Any idea what i'm doing wrong?

Cheers!

Timo

[wolfchan]

Hi,

    I had try by return below message, and Power BI do pop up and ask for O365 login, but after success login, when go to connect it still say no permission. Any suggestion?

Thank you very much.

---

@v-qiuyu-msft wrote:

Hi @timowille,

The workaround provided by the PG is:

To make this work with Power BI, the endpoint needs to return an URL which looks like

WWW-Authenticate: Bearer authorization_uri="https://login.windows.net/a1a2578a-8fd3-4595-bb18-7d17df8944b0/oauth2/authorize"

Where the GUID is the AAD tenant ID. This cannot be done entirely via configuration, it involves writing code on the service side.

Best Regards,
Qiuyun Yu

---

[o365spo]

Does this mean there is no way to consume AAD authenticated Azure Functions from Power Bi?   REALLY????

[wolfchan]

Hi,

  I also having same issue for Power BI connect to OData in azure app. Is there any new solution that we can use?

I had try to return below message and Power BI do pop up O365 screen for login, but after login, it still say no permission.

WWW-Authenticate: Bearer authorization_uri="https://login.windows.net/a1a2578a-8fd3-4595-bb18-7d17df8944b0/oauth2/authorize"