Sharepoint folder > URL

[Anonymous]

Hello, 

I deposited excel files in a sharepoint folder whose url looks like this: https://mysite.sharepoint.com/sites/Folder1/Folder2/PowerBI

How can I get access to these files?

when I put all the URL in the query I have an error and if I only put https://mysite.sharepoint.com/sites/Folder1, I have too many files and I cannot find mine...

Thank you for your help !

[edhans · Accepted solution]

The SharePoint.Files() function, which is what you used, has a 5,000 (or 10,000?) limit to the files it shows.

However, in that source statement - make sure the Power Query formula bar is showing, change it to SharePoint.Contents. This will show you folders, not files. So usually there you click on Shared Documents, then you can drill down to Folder2, then PowerBI. It is much MUCH faster when your site has a lot of files to browse through.