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,
I had a similar problem and managed to create a workaround utilizing dataflows. In my case the goal is to combine SSAS database with a Sharepoint Excel file into a single data set. Here's what I did roughly:
1) For the Excel on Sharepoint, I created a dataflow to read the Excel. No gateway is selected.
2) In Power Query (Desktop), I created a query for my SSAS database which is on premise (gateway required). Then I created another query where the source is my dataflow that I created in step 1.
3) I published my dataset/report
4) The refresh worked.
Another thing to note here is to make sure you have the most recent gateway installed. This is because the dataflow feature is relativley new in Power BI Service and since you want to use the dataflow as a source in PowerBI you need to make sure you have the most recent gateway installed or at least the one that support connecting to a dataflow from Power Query Desktop.
Hi, J_K, How Are You?.
Thank You Very Much. Today I will try to carry out your advice. I don't remember that I used dataflows before (maybe I did it but I don't know the concept). I then tell him how I left.
Thank You Very Much, again.