Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

Hello,    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 ...
Need Help
kcantor's avatar
kcantor
Community Champion
7 years ago

Anonymous 

Can you provide the new path you wish to transfer to?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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!

    • kcantor's avatar
      kcantor
      Community Champion
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        No offense at all! :D VERY new to this. 

         

        So just to be clear about the steps. 

        1. I'm adjusting the paths on the other users' computer. 
        2. 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!