Forum Discussion
How 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,
You 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.
Hi - I've tried to use the Connect directly (seems the only available option) and still getting the same issue. The only authentication selection I can see is: Anonymous; Windows or Basic, so no OAuth2 selection. I've tried all of these and none see to work.
I am running into a similar issue. I have the Enterprise gatway setup on Azure VM. I am successfully able to add SQL DB and Azure Blob data source connections. But when I try to add conections to Sahepoint Folder, it thows me an error. Can you please let me know if any one has faced such issue and how did you resolve it.
