• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Query - Source folder path changed not working

SbusyCR

New Member
Hi,

I changed the path of the source folder and I am getting an error.

Original path: ...........Excel start up\Get and Transform (aka Power Query)\Test import files PQ

Actual path: ................Excel start up\Get and Transform (aka Power Query)\Test path change

File attached.

Thanks for your help!
 

Attachments

  • temporal.xlsx
    34.4 KB · Views: 1
You need to change it in more than one location for Query using Binary combine.

1. Sample File
2. Transform Sample File
3. Test import files PQ

If this type of folder change can occur relatively frequently. Then I'd recommend setting up parameter. Which is then used to replace all references to folders.
 
Back
Top