Forum Discussion
Online Excel File and Auto refresh
Hi rachaelwalker ,
It think it depends on where the actual file resides.
I guess it's either SharePoint, OneDrive for Business (which is also SharePoint), Teams (which is also SharePoint), a network folder, or a local HDD.
For any SharePoint sources you can use the web connector, no problem. I don't think you even need to set this up as a source on your gateway as these all reside within the MS universe.
For network files, you need to use the full true path of the file, and also set the network destination as a source on your gateway (which must also have authentication to access that location on your network). The full true path would be \\server\true drive name\normal file path.
You will not be able to refresh using an Excel file on a local HDD. If this is the case, move it to either a SharePoint-based location, or to a network location that your gateway can access.
Pete
Hi rachaelwalker ,
It think it depends on where the actual file resides.
I guess it's either SharePoint, OneDrive for Business (which is also SharePoint), Teams (which is also SharePoint), a network folder, or a local HDD.
For any SharePoint sources you can use the web connector, no problem. I don't think you even need to set this up as a source on your gateway as these all reside within the MS universe.
For network files, you need to use the full true path of the file, and also set the network destination as a source on your gateway (which must also have authentication to access that location on your network). The full true path would be \\server\true drive name\normal file path.
You will not be able to refresh using an Excel file on a local HDD. If this is the case, move it to either a SharePoint-based location, or to a network location that your gateway can access.
Pete
BA_Pete it resides on sharepoint online document library. I removed it from gateway and rechecked my credentials and it is now working. Thank you for taking the time to explain. Very informative!