Forum Discussion
Unable to configure an Excel data source from Enterprise Gateway
Currently, on-premise data gateway doesn't support OAuth2 based authentication. We are not able to add the online data sources in data gateway as well as on-premise data sources, so that we can't configure this kind of combined dataset to use data gateway. The workaround is to use personal gateway.
PG have started working on the data gateway to fix this issue. See: Combine enterprise gateway and online data sources. Their current ETA is end of August, so we just need to wait for the new version of on-premises data gateway.
Best Regards,
HerbertHi Herbert,
Thanks for you swift reply! Ok, then I know and will use the personal gateway or put the file on a network disk instead. But it feels important that the functionality to combine on-prem and online data since many of my customers are moving there files over to OneDrive.
Rgs,
//Patrick
Microsoft Employee
Currently, on-premise data gateway doesn't support OAuth2 based authentication. We are not able to add the online data sources in data gateway as well as on-premise data sources, so that we can't configure this kind of combined dataset to use data gateway. The workaround is to use personal gateway.
PG have started working on the data gateway to fix this issue. See: Combine enterprise gateway and online data sources. Their current ETA is end of August, so we just need to wait for the new version of on-premises data gateway.
Best Regards,
Herbert
Hi Herbert,
Thanks for you swift reply! Ok, then I know and will use the personal gateway or put the file on a network disk instead. But it feels important that the functionality to combine on-prem and online data since many of my customers are moving there files over to OneDrive.
Rgs,
//Patrick