Forum Discussion
How to change the source path when using the folder option in Get Data
No offense at all! :D VERY new to this.
So just to be clear about the steps.
- I'm adjusting the paths on the other users' computer.
- I'm refreshing the model on the other users' computer.
So, yes, I am. Is that an issue? The other user will be updating the data from folders on his local drive. He would therefore be required to refresh the data, no?
Thanks!
Anonymous
You are correct. I only had to ask. :smileywink:
Have you tried creating a new query in the model hitting that file directly just in case there is some qwirk with the system that changes the file path slightly? We have some system files that default to a specific drive that has to be manually adjusted when we move from computer to computer.
in the existing data model, do a new hit to the folder and then grab the folder path directly from that query to switch into the query. You will need to put in in every instance of the connections, your sample, your combine, all of them.
If that doesn't work, can you grab the entire query from the advanced editor tab and paste it into the forum here so that it can be reviewed?