Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
FS
Frequent Visitor

Unable to schedule refresh with sharepoint and database

‎09-29-2016 02:10 AM

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 got a gateway set up and working no problem - I have no issues scheduling a refresh when I only use the database as my source of data and I have no problems when using files uploaded on Sharepoint either.

 

But when I upload my .pbix file with these two sources and go to "Schedule refresh", I get prompted to download data gateway.

 

I hope this makes sense, my english is not that great.

Labels:
Message 1 of 13
10,056 Views
0
1 ACCEPTED SOLUTION
kevhav
Continued Contributor
Continued Contributor
In response to FS

‎10-04-2016 01:24 PM

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

View solution in original post

Message 8 of 13
11,512 Views
12 REPLIES 12

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All
Top Solution Authors
View All