Forum Discussion

FS's avatar
FS
Frequent Visitor
9 years ago
Solved

Unable to schedule refresh with sharepoint and database

First off, sorry if this has been already asked/answered.   I am having trouble scheduling a refresh of one file with two data sources - one is a file on SharePoint, the other is a database. Ive g...
Need Help
  • kevhav's avatar
    kevhav
    9 years ago

    I heard back from Microsoft that...

     

    • Currently, the On-Premises Gateway does not support OAuth (a requirement for SharePoint Online connectivity); so if you have a dataset that has both SharePoint Online and on-premise data sources, that dataset cannot be refreshed using an On-Premises Gateway.

    • As mentioned here, you can use a Personal Gateway to set up a scheduled refresh of a dataset that has both SharePoint Online and on-premise data sources. This is what they recommended.

    • Microsoft is investigating the possibility of a change to allow OAuth with the On-Premises Gateway, but have have no timelines for it.

    • They recommended that I continue to to use the On-Premises Gateway for datasets where it works, but use the Personal Gateway as a "workaround" for my one dataset that has both SharePoint Online and on-premise data sources
FS's avatar
FS
Frequent Visitor
9 years ago

Thanks v-qiuyu-msft, I tried installing personal gateway and had no problems with setting up scheduled refresh.

 

But I would like to utilize the on-premises (Enterprise) gateway i have been using for everything else until now for this task as well - is it even possible?

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi FS,

 

As mentioned in my original post, in your scenario, as the dataset contains two data sources, on-premises data source and SharePoint Online file, it's not supported to use on-premise gateway to build connection. Only personal gateway is available now for us to setup schedule refresh.

 

Best Regards,
Qiuyun Yu