Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    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.

edhans's avatar
edhans
Community Champion
5 years ago

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.