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
That's interesting! But I need to mix the data from my SQL data source with the data from the CSV in OneDrive. I think that's not possible with what you're suggesting right?
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?
Hi paulwozniak,
You can use them for different datasets. For one dataset which contains only on-premises data source, you are able to choose personal gateway or on-premises gateway when setting schedule refresh.
Thanks,
Lydia Zhang