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
- jennratten
Super User
Hello! You should use the SharePoint.Files connector instead. That will return a table which contains the folder path that you can filter.
- christinepayton
Most Valuable Professional
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.
