WWW-Authenticate and multiple different APIs on same endpoint

[fb]

Further to https://community.powerbi.com/t5/Desktop/AADSTS50001-Specify-resource-id-in-www-authenticate-respons... is there a way yet to specify the resource to be used in the www-authenticate response that will get used by the built-in web connector?

I have multiple different APIs, each with their own permissions and protected by Azure AD, hosted on one host - e.g. https://api.domain.com/one, https://api.domain.com/two. Azure AD app registration requires an identifier url to be unique, meaning only one API can currently work at a time using https://api.domain.com. https://docs.microsoft.com/en-us/power-query/handlingauthentication#azure-active-directory-authentic... describes a Resource value that can be passed, but I assume that this doesnt apply to the built-in web connector as I have tried without success.

PS - I am using Power Query from Excel if that matters.

[fb · Accepted solution]

Posted at https://techcommunity.microsoft.com/t5/office-365/excel-powerquery-organisational-auth-www-authentic...

[v-kelly-msft]

Hi  @fb ,

It's an Excel add-in,office 365 forum would provide a more professional and effective solution.

Would you pls mark the reply as answered to close this case?
If you need further here,you're welcomed to be back here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[fb]

But its the Power Query component and they will more than likely refer me back to here...

[v-kelly-msft]

Hi @fb,

Check whether below reference help:

https://docs.microsoft.com/en-us/power-query/connectors/web/web

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[fb]

Thanks, but nothing in there that I am not already using. I think this may need a bug report/feature request in the correct place. Any ideas on the best place to post this? I've found https://github.com/microsoft/DataConnectors but not sure if that applies to PowerQuery within Excel.

For now I have it working using CNAMES (e.g. https://one.api.domain.com, https://two.api.domain.com), but this is far from ideal.

[v-kelly-msft]

Hi  @fb ,

If it's an Excel related case,I would suggest you post a thread in Office 365 forum:

https://techcommunity.microsoft.com/t5/office-365/ct-p/Office365

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!