Forum Discussion
Solved
How to configure On-premises Gateway to SharePoint Folder source
Hi everyone! I tryed to configure an on-premises to SharePoint Folder source but I did not have success. In Power BI Desktop it works very well, I could connect and read the files. However, w...
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,
This feature is now live. Check this document:
https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud
Worked like a charm, thank you.