Pull data from a REST API which has Authentication

[vikramd8]

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 

[Eric_Zhang]

---

@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