cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver III
Resolver III

Retrieving Files from SharePoint

Hello,

 

I am trying to retrieve some files that my company has in SharePoint. I tried to retrieve the files using Get Data -> SharePoint Folder. This gives you every file that is contained in the root address (as expected), however, the files that I want do not appear. In fact, there are many files contained in subfolders that do not appear in the list. I believe that the SharePoint connector has some sort of limit of how many files it can retrieve. I believe that I am having the exact same issue as the problem posted here, but the solution posted here is more of a workaround. While my plan B was to implement the solution that was presented in that post, I wanted to see if anyone else has any suggestions. 

 

I'd appreciate any help.

 

Thank you.

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Retrieving Files from SharePoint

@vega

 

I can't reproduced your issue. It will show all files under sub folders when we input the root url. 

 

3906287.PNG

 

Regards,

 

Highlighted
Resolver III
Resolver III

Re: Retrieving Files from SharePoint

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.

Highlighted
New Member

Re: Retrieving Files from SharePoint

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 2018-02-19 09_55_46-.png

 

When I try to view errors I get this:

2018-02-19 10_16_12-BOT Log Summary_ - Query Editor.png

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Top Solution Authors
Top Kudoed Authors