Forum

Source doesn't exis...
 
Notifications
Clear all

Source doesn't exist for Power Query folder

2 Posts
2 Users
0 Reactions
112 Views
(@jycccwjc)
Posts: 64
Estimable Member
Topic starter
 

I have been using PQ for years. However, this is the first time I encountered it. I PQ a folder, and it took hours and finally only returned an error message: Source doesn't existPQ-Source-Doesnt-Exist.PNG

This folder is under Summer Camp 2023-->2023 Summer Camp Enrollment-->SC-In Person--> all CSV files (you can see from the attached screenshot.

 

I have been running the same format/process for more than 10 years, from 2009 to 2023.

 

Can someone tell me what happened?

 

Thanks!

 

Jim

 
Posted : 27/03/2023 10:47 pm
(@mynda)
Posts: 4761
Member Admin
 

Not sure, Jim. I'm a bit confused as to what "Section1/" in the error is referring to. I'm wondering if something has a forward slash in a name. If so, I'd remove that as using operator characters like this cause errors. That said, it doesn't appear to be in the file path, so I'm wondering if it's the sheet name in the csv file.

The only other thought is that the file names are very long and they might be over the length limit.

I'd try making a copy of one of the files, renaming it to something short, and then trying to get the file from a folder. Continue adding the files to that new folder until you trigger the error again. 

Mynda

 
Posted : 28/03/2023 3:02 am
Share: