Forum Discussion
Strange Gateway issue
Here is how the issue occurs:
Have multiple CSV files in a folder. Link your gateway to the folder. At this point everything is happy.
Create a new query that does a merge on 2 or more of those CSV files. Now gateway is unhappy.
Update gateway to link to each file directly, gateway is happy again.
Its not a solution, but its a work around for right now.
Here is how the issue occurs:
Have multiple CSV files in a folder. Link your gateway to the folder. At this point everything is happy.
Create a new query that does a merge on 2 or more of those CSV files. Now gateway is unhappy.
Update gateway to link to each file directly, gateway is happy again.
Its not a solution, but its a work around for right now.
Hi Anonymous
The problem I have is that when setting the data source for the specific file, I cannot as my files is saved in a SharePoint Site Folder, not a Windows Folder. So it does not allow me to set the file path with a "http://" type of path.
Also, I have not upgraded the gateway since last year. Would that fix the problme if I do now?
Thanks for your help.
I've not personally tested a sharepoint source for this issue, so i'm unsure if the merge issue is present.
Our gateway is a few versions out of date, i'm looking to upgrade myself soon. Just balancing the availablity of my infrastructure team.
Sorry I cannot provide much further insight.
Anybody still experiencing this issue?
I have a bunch of web data that cannot auto-refresh because it's appended into a single dataset.
