Forum Discussion
WWW-Authenticate and multiple different APIs on same endpoint
Further to https://community.powerbi.com/t5/Desktop/AADSTS50001-Specify-resource-id-in-www-authenticate-response/m-p/322353#M143627, 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-authentication 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.
6 Replies
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,
KellyDid I answer your question? Mark my post as a solution!
Hi fb,
Check whether below reference help:
https://docs.microsoft.com/en-us/power-query/connectors/web/web
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
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.
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,
KellyDid I answer your question? Mark my post as a solution!
But its the Power Query component and they will more than likely refer me back to here...
