Forum Discussion
Connection Error On Premises Gateway - SQL Server and Sharepoint (O365)
AntonioPalomas,
When combining on-premises SQL Server data source and SharePoint online data source in a single dataset, we need to add all the data sources within on-premises gateway in order to refresh the dataset. But it doesn't support OAuth type in on-premises gateway and we use OAuth type authentication to connect to SharePoint Online, it is impossible to add the SharePoint Online data source within on-premises gateway currently.
To work around this issue, please use personal gateway to refresh the dataset.
There is an idea for your reference.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources
Regards,
LydiaHi Lydia
Thank you very much for the information.
AntonioPalomas,
When combining on-premises SQL Server data source and SharePoint online data source in a single dataset, we need to add all the data sources within on-premises gateway in order to refresh the dataset. But it doesn't support OAuth type in on-premises gateway and we use OAuth type authentication to connect to SharePoint Online, it is impossible to add the SharePoint Online data source within on-premises gateway currently.
To work around this issue, please use personal gateway to refresh the dataset.
There is an idea for your reference.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources
Regards,
Lydia
Hi Lydia
Thank you very much for the information.