Folder Path length exceeds maximum length

[Skybluekid]

Hi

I have set up a query that goes through folders to collect data. However, it gets to certain folder and then fails as it say :

The File name (file path name) is longer than the system -defined maximum lenght.

Is there any work around for this?

Thanks is advance.

 

[jdellasala]

Command Prompt to the rescue!
Open a command prompt and type HELP SUBST to see the syntax of the command. What it can do is create a virtual drive letter out of a folder, something like this:

Subst X: C:\Users\Username\abcdefg\qwertyuiop\asdfghjkl

Now you can use X: as that path in Power Query. It's been so long since I've used the command, I don't remember if it will come back after a reboot, but I think it will. I say that because if/when you no longer need it, the command Subst X: /D will delete the drive letter.

I'm not aware of any way to do that in native Windows.

 

[Skybluekid]

Thank you, jdellasala. Really stupid Question, how do you now apply the X: path in Power Query?

 

[jdellasala]

Thank you, jdellasala. Really stupid Question, how do you now apply the X: path in Power Query?

Same as you would with any drive. Just browse to it or type X: or whatever letter you use.