Forum Discussion
Help Connecting Power Query to a Sharepoint folder with spaces in the URL
Hello Experts, I need help connecting Power Query to a Sharepoint folder to connect to all the files in a subfolder. The full URL has special characters in it like %20 and will not work when I try ...
When you are using the SharePoint Folder connector, you can filter on the path there to get to your folder. If I recall, it doesn't have the full path in it, just everything after the site, so you'd just copy the last chunk of your path to filter there. Replace %20s with spaces if you see that the path does not contain them in the query editor, they are a translation of the space character.