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

%3CLINGO-SUB%20id%3D%22lingo-sub-2279804%22%20slang%3D%22en-US%22%3EExcel%20PowerQuery%3A%20Organisational%20Auth%2C%20WWW-Authenticate%20and%20different%20APIs%20on%20same%20endpoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279804%22%20slang%3D%22en-US%22%3E%3CP%3EOriginally%20posted%20at%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FPower-Query%2FWWW-Authenticate-and-multiple-different-APIs-on-same-endpoint%2Ftd-p%2F1780239%2C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FPower-Query%2FWWW-Authenticate-and-multiple-different-APIs-on-same-endpoint%2Ftd-p%2F1780239%2C%3C%2FA%3E%20who%20referred%20me%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFurther%20to%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FDesktop%2FAADSTS50001-Specify-resource-id-in-www-authenticate-response%2Fm-p%2F322353%23M143627%2C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FDesktop%2FAADSTS50001-Specify-resource-id-in-www-authenticate-respons...%3C%2FA%3E%20%3CSTRONG%3Eis%20there%20a%20way%20yet%20to%20specify%20the%20%3CU%3Eresource%3C%2FU%3E%20to%20be%20used%20in%20the%20www-authenticate%20response%20that%20will%20get%20used%20by%20the%20built-in%20Power%20Query%20web%20connector%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20multiple%20different%20APIs%2C%20each%20with%20their%20own%20permissions%20and%20protected%20by%20Azure%20AD%2C%20hosted%20on%20one%20host%20-%20e.g.%20%3CA%20href%3D%22https%3A%2F%2Fapi.domain.com%2Fone%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fapi.domain.com%2Fone%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Fapi.domain.com%2Ftwo%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fapi.domain.com%2Ftwo%3C%2FA%3E.%20Azure%20AD%20app%20registration%20requires%20an%20identifier%20url%20to%20be%20unique%2C%20meaning%20only%20one%20API%20can%20currently%20work%20at%20a%20time%20using%20%3CA%20href%3D%22https%3A%2F%2Fapi.domain.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fapi.domain.com%3C%2FA%3E.%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-query%2Fhandlingauthentication%23azure-active-directory-authentication%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-query%2Fhandlingauthentication%23azure-active-directory-authentic...%3C%2FA%3E%20describes%20a%20Resource%20value%20that%20can%20be%20passed%2C%20but%20I%20assume%20that%20this%20doesnt%20apply%20to%20the%20built-in%20web%20connector%20as%20I%20have%20tried%20without%20success.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2279804%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESecurity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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