Forum Discussion
Schedule Refresh with ODBC Source
cmotisi,
Do you connect to Excel/csv files stored in SharePoint Online?
If so, you are combining online data sources and on-premises data source in a single dataset, in this scenario, you would need to use personal gateway instead of on-premises gateway to refresh your dataset as currently on-premises gateway doesn't support OAuth type authentication and thus it is not possible to add the Excel/CSV data source withine on-premises gateway.
However if you connect to Excel/csv files tored in on-premises SharePoint, please add the Excel/csv data source within on-premises gateway, then you will be able to use on-premises gateway to refresh your dataset.
Regards,
Lydia
My dataset contains ad ODBC Datasource and excel/csv datasouce, like following:
Thank's
Claudio
cmotisi,
Do you connect to Excel/csv files stored in SharePoint Online?
If so, you are combining online data sources and on-premises data source in a single dataset, in this scenario, you would need to use personal gateway instead of on-premises gateway to refresh your dataset as currently on-premises gateway doesn't support OAuth type authentication and thus it is not possible to add the Excel/CSV data source withine on-premises gateway.
However if you connect to Excel/csv files tored in on-premises SharePoint, please add the Excel/csv data source within on-premises gateway, then you will be able to use on-premises gateway to refresh your dataset.
Regards,
Lydia
Yes, I Connect to Excel/Csv files on SharePoint Online on Office365.
I'll try to install a personal gateway.
Regards,
Claudio