Help Connecting Power Query to a Sharepoint folder with spaces in the URL

[TimTeska]

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?

Full URL https://company.sharepoint.com/teams/GlobalReportingTeam/Documents/Company%20JnJ%20Payable%20Indemni...

Path as it appears in OneDrive

C:\Users\login\OneDrive\Company Payable Indemnification Project\Completed Reports

[christinepayton]

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. 

[jennratten]

Hello!  You should use the SharePoint.Files connector instead.  That will return a table which contains the folder path that you can filter.