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
DavidMoss's avatar
DavidMoss
Advocate V
9 years ago

Hi, Has anyone had an update on this issue where we have two data sources in our development environment been (A) Sharepoint Online and (B) an onPremises database (this user case its MS Access) ?

Both data sources are in the same .pbix file

After publishing the file to the PBI service then when selecting schedule refresh from the dataset ... icon and after clicking 'gateway settings' it is stating personal gateway is offline.

We actually have 2 fully functioning on-premises enterprise gateways which work perfectly for datasets with on-premises data only.

We also have sharepoint only datasets that refresh (they don't need the gateway as they are not on premises).

 

With this dataset because there are both an online (A) and an on premises (B) data source after clicking 'gateway settings' when configuring the schedule refresh the PBI system does not find either of the on-premises gateways but only states the personal gateway is offline. Implying we need to install and use the personal gateway.

 

I am understanding that Microsoft advise to use the personal gateway to resolve this issue.

As of this date March 2017 month end is this still advised ?

Or has the On-Premises gateway been updated to accomodate this issue ?

If so please point to where you read this.

 

Please post your expereiences aswell re dual datasources (A+B) schedule refreshes. Thanks.