Forum Discussion
Sharepoint folder > URL
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 !
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.
1 Reply
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.