Data Gateway - REST API

[darentengmfs]

Hi,

How do I add REST API to the Data Gateway? What are the credentials needed?

Thanks!

[Anonymous · Accepted solution]

Hi @darentengmfs,

If your rest API is connected based on a web connector, it means you are work with a cloudy data source.
If you report not include other type of data sources, you not need to use a gateway to handle this type of data source refresh. Verify your credentials at 'dataset' -> 'data source credentials' then it will refresh automatically.

Regards,

Xiaoxin Sheng

[darentengmfs]

Thanks @lbendlin and @Anonymous for helping in this.

I just realized that the things you guys mentioned was never there at first because the credentials for my SQL server was not entered correctly, that's why I did not have the option to configure the data source credentials, and that's why I was confused about not needing to add REST API to the data gateway. After fixing it, I am able to finally refresh them.

Daren

[darentengmfs]

Hi @Anonymous @lbendlin 

I am connecting Rest API with the web connector. I was given permission to access to the API so I am not sure how refreshing the report on Services works since the API is permission-based?

Daren

[Anonymous · Accepted solution]

Hi @darentengmfs,

If your rest API is connected based on a web connector, it means you are work with a cloudy data source.
If you report not include other type of data sources, you not need to use a gateway to handle this type of data source refresh. Verify your credentials at 'dataset' -> 'data source credentials' then it will refresh automatically.

Regards,

Xiaoxin Sheng

[darentengmfs]

Hi @Anonymous 

My dataset do have several other data sources, e.g. SQL Server, Sharepoint folder.

[lbendlin · Accepted solution]

Simplify your testing - create a new PBIX that only has the web API data source.  Make sure that works as expected both on the desktop and the service.  Only then add the other on-prem data sources (and activate the gateway).

[Anonymous]

Hi @darentengmfs,

What type of connector are you worked? If you are using web connector to get data from rest api, it does not require to use a gateway to handle refresh.

Data refresh in Power BI 

If you need using rest API with other type of data sources who required to use the gateway to handle refresh, you can turn on the option to use gateway manage cloudy Datasource refresh.

Merge or append on-premises and cloud data sources 

Regards,

Xiaoxin Sheng

[lbendlin]

Is your API endpoint on premise? Why would you need a gateway?