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 to connect by just pasting the full url as the data source.
I also tried to connect using SharePoint online list option and starting with the root of the url - http://company.sharepoint.com but after I connect the folders appear as tables and I cannot connect to the sub folders I need to.
Can someone help?
Path as it appears in OneDrive
C:\Users\login\OneDrive\Company Payable Indemnification Project\Completed Reports
2 Replies
Hello! You should use the SharePoint.Files connector instead. That will return a table which contains the folder path that you can filter.
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.
