Forum Discussion
Retrieving Files from SharePoint
I can't reproduced your issue. It will show all files under sub folders when we input the root url.
Regards,
Right, as I stated I believe it is a limit to the number of files it can retrieve. In your example, there are only 12 files. The SharePoint root address that I entered has over a thousand files. When I filter for a specific file, I get a blank table in return because Power BI is not retrieving all the files from the SharePoint folder, due to some sort of limit.
I'm facing similar problem. It may be linked with two facts:
- most likely your query connects to the whole Sharepoint library in the first place and you filter files down the stream in your query
- it may be linked with the fact that Sharepoint has limit of ~3000 files per view
I made a test trying to retrieve files and I'm getting errors (3500
When I try to view errors I get this:
