Forum Discussion
Advocate IIHow to configure On-premises Gateway to SharePoint Folder source
Hi rodrigomo，
On-premises gateway doesn't allow you to combine online data sources and on-premises data sources. This is a known issue that has been submitted in the following link and the feature that using on-premises gateway to work with online data sources is under review, please vote it.
To work around the issue in your scenario, you can use the personal gateway to schedule refresh for your dataset when combining SharePoint Online data source and on-premises SQL Server data source.
Thanks,
Advocate IIYou are right!
It's just to confirm the credentials and not is necessary to configure a gatway when just SharePoint is being used.
Thanks for this!
However, my application reads data from SharePoint and(+) SQL Server base. In this case, I have an on-premises gateway to refresh the SQL data and it's not working. Apparently, the PBI services is waiting a personal gatway, but I need an on-premises gateway. See the PBI message below.
I have used on-premises gateway for SQL data for other applications and it's work very well when just SQL data were used. SharePoint source can causes some problem or conflict?
Thanks!
You don't need to include it as a data source in your On-Premis Gateway.
Under Gateway Connection, select "Connect directly" then under Data Source Credentials set your sharepoint online credentials using OAuth2 authentication method.
you should be able to refresh or schedule the refresh of your dataset using this configuration.