Forum Discussion

rodrigomo's avatar
rodrigomo
Advocate II
9 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources

    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,

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources

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,

rodrigomo's avatar
rodrigomo
Advocate II
9 years ago

Uhmmm.. interesting!

Well, I will review the data source solution for my appliation.

Thanks Lydia

Best!