Forum Discussion
How to change the source path when using the folder option in Get Data
Sure can:
FROM: C:\Users\emily.newell\Travelopia USA Inc\Quark Marketing - Documents\Reporting\Website Wistia\
assuming sample file of: "201806 - 201906 Wistia Stats - Videos.csv"
TO: C:\Users\nicolas.singh\Travelopia USA Inc\Quark Marketing - Documents\Reporting\Website Wistia\
assuming the same sample file.
Alternatively, could I transfer the entire process to look at a GoogleDrive folder, rather than a local folder?
I can't use a sharepoint folder because of the way in which our internal sharepoint permissions are setup. I receive an error.
Thanks!
Please do not take any offense at this but when you switch all the folder paths, are you trying to refresh the model on the other user's computer?
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?