Forum Discussion
OneDrive refresh via Data Gateway
Hi paulwozniak，
Using On-premises gateway, it is not possible to schedule refresh for your dataset when you mix on-premises SQL data source and CSV on Onedrive. 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.
However, using personal gateway, you are able to schedule refresh for the dataset when you mix data sources(on-premises SQL and CSV on Onedrive).
In addition, you can install the personal and On-premises gateway gateway on the same computer.
Thanks,
Lydia Zhang
Hi paulwozniak，
Using On-premises gateway, it is not possible to schedule refresh for your dataset when you mix on-premises SQL data source and CSV on Onedrive. 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.
However, using personal gateway, you are able to schedule refresh for the dataset when you mix data sources(on-premises SQL and CSV on Onedrive).
In addition, you can install the personal and On-premises gateway gateway on the same computer.
Thanks,
Lydia Zhang
Voted! Thank you.
Can I use both on-premises gateway and personal gateway at the same time on one machine and profile?