How to change the source path when using the folder option in Get Data

Question

Hello,&nbsp;&nbsp;I am new to Power BI and have been building a dataset using the 'Folder' option (i.e. multiple .csv files are combined to create one file in power query). I now want to give someone else the capacity to use this pbix file. Because the original sources referenced a personalized path (see below), I don't seem to be able to make the transfer.&nbsp;&nbsp;= Source{[#"Folder Path"="C:\Users\emily.newell\Travelopia USA Inc\Quark Marketing - Documents\Reporting\Website Wistia\",Name="201806 - 201906 Wistia Stats - Videos.csv"]}[Content]&nbsp;I have tried [Change Sources] and received an error in the 'Sample Query' that is a part of the Transform File step. I then adjusted those folder paths as well, but have still received an error.&nbsp;&nbsp;Would love suggestions.&nbsp;Many thanks!

kcantor · Answer

Anonymous&nbsp;
Can you provide the new path you wish to transfer to?

anonymous · Answer

Sure can:&nbsp;&nbsp;FROM: C:\Users\emily.newell\Travelopia USA Inc\Quark Marketing - Documents\Reporting\Website Wistia\&nbsp;assuming sample file of: "201806 - 201906 Wistia Stats - Videos.csv"&nbsp;TO:&nbsp;C:\Users
icolas.singh\Travelopia USA Inc\Quark Marketing - Documents\Reporting\Website Wistia\&nbsp; &nbsp;assuming the same sample file.&nbsp;Alternatively, could I transfer the entire process to look at a GoogleDrive folder, rather than a local folder?&nbsp;&nbsp;I can't use a sharepoint folder because of the way in which our internal sharepoint permissions are setup. I receive an error.&nbsp;&nbsp;Thanks!

kcantor · Answer

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?

anonymous · Answer

No offense at all! :D VERY new to this.&nbsp;&nbsp;So just to be clear about the steps.&nbsp;I'm adjusting the paths on the other users' computer.&nbsp;I'm refreshing the model on the other users' computer.So, yes, I am. Is that an issue?&nbsp; The other user will be updating the data from folders on his local drive. He would therefore be required to refresh the data, no?&nbsp;Thanks!&nbsp;

kcantor · Answer

Anonymous&nbsp;
You are correct. I only had to ask.&nbsp;: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.&nbsp;
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?

Forum Discussion

How to change the source path when using the folder option in Get Data

5 Replies

Related content

OneDrive Folder as source

Change Source from 'Folder' to 'SharePoint Folder'

Change Source from File to Folder?

Change data Source from File to Folder

Changing Data Source