Excel Power Query DataSource.NotFound: File or Folder: We couldn't find the folder. Solved! EMT 1662

If you get this error: DataSource.NotFound: File or Folder: We couldn't find the folder. To fix it: Update Excel Power Query File or Folder Path with Data Source Settings in Data Ribbon Tab, Get & Transform Data group, Data Source Settings option.

Import Text Files Using Power Query. Power Query Error. Download did not complete. Power Query Error. Data Could Not Be Loaded. File Path Error in Power Query. Folder Path Error in Power Query. How to Update in Power Query. Refresh Data Error in Power Query. I get an error when I refresh in Power Query. Data Source Not Found Power Query Error. Need help with Data Source Not Found Error in Power Query.

[Velisus]

Your tone of voice is perfectly matched with my brain. THANK YOU for sounding slightly annoyed and being brief and helpful!

[msmith]

Thanks for sharing this. This is much faster than opening the query edit window and browsing to the Source step.
For many scenarios, I prefer relative paths using the method that Oakley Turvey shares in his video (second comment).

[dutchcadillac]

Great tip. I have to do this for work when building new reports for multiple years, but I had found the solution in a different manner, but to the same browse pop up. Thanks for the fast tip!!!

[masterof]

Hi Mike, I am so looking forward to read your new book, will it be ready before XMAS 2020? Will it have a chapter to talk about how to refresh the queries in the sequence that you want to? For example, I want to refresh those queries that imports the data first, then those ones who processed them (some may have dependencies to each other, so some should be ahead of others), then refresh the Data Model, and finally to refresh the pivot tables on the worksheets. Thank you Mike, looking forward to it!

[wayneedmondson]

Hi Mike.. what a killer tip.. lots of time will be saved with this one! Thanks to you and pmsocho for sharing this great trick. Thumbs up for ExcelIsFun and the Team!!

[kiwikiow]

Thank you Mike and pmsocho for sharing this tip. 😊👍

[tecwzrd]

That's easy enough to do when it's your file that you moved somewhere, I usually get this error when I'm receiving a file from a co-worker and they reference one of their files on their computer :|
Is there a magic trick on how to teach your co-workers to source data within the file they send you ;) It Seems no matter how many times I tell them or tell them to at least include the files they source they still do it. Thanks for all you do Mike and hope you and yours are healthy and safe, you make my job so much easier with your excellent tutorials and tips.

[dangerousmagnous]

Thank you! Saved me work and headache :)

[rrrprogram]

Wow.... Awesome there is always room to learn

[darrylmorgan]

Boom!Great Tip pmsocho..Thank You For Sharing The Great Info Mike :-)

[nicholaslabar]

Holy mackeral. You just saved my work (and sanity)!

[HusseinKorish]

Absolutley amazing ... i usualy go to data> Getdata > launch power qwery editor > data source setting button > and browse for the source ... Thanks Mike .... Thanks pmsocho

[robrayborn]

This is great! Going to save me some time! Thank you very much!

[williamarthur]

Great tip, this would have saved me lot of bother in the past .

[MalinaC]

Mike will solve EVERY problem :) Thanks for sharing :)

[spilledgraphics]

Excelent Mike!!! yes! something the obvious can be a bit hidden!

[musethalia]

Thank you! just what I needed to fix my report.

[rebeccashaffer]

Hi Mike, I have a quick excel issue that I can’t seem to figure it out and I know it has to be simple! I basically want to assign a name a certain color formatting based on a person’s qualifications. I have a sheet containing the roster and qualifications, on a second sheet, I have a weekly schedule. My intent is that every time I type someone’s name into the time slot, it automatically turns the corresponding color. Any advice on the conditional formatting formula best suited for this would be much appreciated!! Thanks!

[Al-Ahdal]

Great...First Like & Comment.... 👍👌

[zaydarendse]

aah man... thanks so easy!! thanks for sharing and caring :)