Forum Discussion
PowerQuery import from Folder dont work for network folders
well, this is interesting, because it actually works :)
I'll do some more testing, but yeah..
Thing is, if I want to make a data silo for my company, each computer maps network shares differently, and it makes a problem.
That is why I tend to use \\server\share structure.
The thing is.. for one share that works my path is:
= Folder.Files(Source&"\source\TV")
where Source is defined in seperate query as "\\server\share_folder\folder"
and it works for only specific share_folder\folder
on all other shares it doesn't work, so it must be something other than folder.files doesn't recognize "\"
I would like to know what it is, because other solution makes me organizational problems..
Thanks for advice so far, it's been really useful
from my experience "\" is not an issue, "/" never worked for me, but it doesn't seem to be relevant in your case
so you can use Files.Folder for a single folder on a specific server, but not for any other folders on the same server? Interesting indeed, anything special about that folder? connecting to subfolders or higher folders works as well?
I agree mapping is not a sustainable solution, but if it works for you, then it proves it's not an access issue
I find nothing special about it except it has no share policies.. its public to all within domain.
That is why Im asking around :) not sure what could block access to folder.