Forum Discussion
Scheduled Refresh for two data sources
I was wondering if it is possible to to enable a sheduled refresh when a dataset contains data from two sources; one from sql server and the other from an excel spreadsheet (which can be stored local...
Hi v-sihou-msft
What you said in adding two datasources to the Enterprise gateway and scheduling it is perfect.
However, the same is not working with Sharepoint as source.
Ex: I have a dataset with 3 diff sources.
Teradata
Odata
Sharepoint
I am able to add Teradata and Odata to on premise gateway but unable to add Sharepoint due to which the data refresh cannot be scheduled on Enterprise gateway.
Sharepoint is authenticated by OAuth and which is a Limitation at the moment.
LimitationsOAuth is not a supported authentication scheme with the On-Premises Data Gateway. You cannot add data sources that require OAuth. If your dataset has a data source requiring OAuth, you will not be able to use the gateway for scheduled refresh.
May I know if there is any solution for this. What would be the better way to approach in this case?