Forum Discussion
AliakseiIvaneka
Advocate I
3 years agoUsing a data source in SharePoint without configuring the On-premises data gateway
Hi. On the project, as one of the data sources, I need to use xlsx files stored in SharePoint and to configure scheduled refreshing, I need to use the On-premises data gateway, but I would like to kn...
christinepayton
Most Valuable Professional
3 years agoIt depends on whether you're using SharePoint Online or on-premise. SharePoint Online does not require the gateway, on-premise does. The connection method varies depending on whether you're trying to combine multiple similarly structured files or not.