Pull data from a REST API which has Authentication

vikramd8 — Thu, 26 Oct 2017 17:59:57 GMT

Hi All,

I have a requirement to use multiple data sources from REST API and show it in power BI Dashboard and i have followed below steps to do so.

1. chose we source and entered a link provided.

2. Im able to connect to the source and gets a the result as follows.

where this is not the data which is present or expected from the source.

3. when i goto web view and see, i get below put, get etc.. calls.

4. This didnt ask me for any authentication.

5. There is a user id and password provided to generate token to be used for authentication for the api calls.

PLease help me to bring my desired data set and make periodic refreshes without any glitches.

Thanks in advance...

Vikram

Re: Pull data from a REST API which has Authentication

Eric_Zhang — Fri, 27 Oct 2017 06:45:05 GMT

@vikramd8 wrote:

Hi All,

I have a requirement to use multiple data sources from REST API and show it in power BI Dashboard and i have followed below steps to do so.

1. chose we source and entered a link provided.

2. Im able to connect to the source and gets a the result as follows.

where this is not the data which is present or expected from the source.

3. when i goto web view and see, i get below put, get etc.. calls.

4. This didnt ask me for any authentication.

5. There is a user id and password provided to generate token to be used for authentication for the api calls.

PLease help me to bring my desired data set and make periodic refreshes without any glitches.

Thanks in advance...

Vikram

@vikramd8

It just doesn't ask for authention for calling a custom API in get data -> web(when Anonymous specified). The keypoint in your case is how to get the token with the user&pwd, is there some API that can return the token with user&pwd in your case? You could reference Get Data from Twitter API with Power Query

topic Pull data from a REST API which has Authentication in Developer

Pull data from a REST API which has Authentication

Re: Pull data from a REST API which has Authentication