Excel PowerQuery: Organisational Auth, WWW-Authenticate and different APIs on same endpoint

Occasional Visitor

Originally posted at https://community.powerbi.com/t5/Power-Query/WWW-Authenticate-and-multiple-different-APIs-on-same-en... who referred me here.


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 Power Query 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.

0 Replies