Web datasource Azure App Service API - Autentication problem

[MagnusLarsson]

Hi,

We have developed an Azure app service API that requires users to be signed in to AzureAD to get access. Following the access, the user get a token used for following the data retrieval step. Trying to set up the data access in PowerBI desktop we fail to get the token since we are not logged in and if we provide login information in data source settings the response is that we can only use anonymous login. We have also tried are using Power Query.

Has anyone else experienced this problem? Any clues on how to proceed are appreciated.

[v-yulgu-msft]

Hi @MagnusLarsson,

In such a scenario, you may failed to connect to Web API by selecting an authentication type in UI, you should specify the access token and authentication by writing Power Query manually. Please refer to below blog for details:

Get Data from Twitter API with Power Query

Best regards,

Yuliana Gu