Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Not all rows are loaded froma a Sharepoint library

Hi all,

 

I have an issue with loading data from a SharePoint document library. The library contains ~1000 files and has more than 12 lookup columns. Therefore, I created a default view without lookup columns. Using the SharePoint Online data connector (2.0, default view) I can successfully connect to the library. However, it only loads 80 rows. 

 

I tried the following:

  • Create a new view, with and without folder flattening > no difference
  • Connect using an OData feed, but then I run into the lookup column threshold
  • Connect to another large library with more than 12 lookup columns, which can be synced without any issues. 

 

Anybody any ideas what is going on here?

 

Thanks!

  • lbendlin's avatar
    lbendlin
    2 years ago

    very sorry to hear that. The hard limit for Power BI is 6 lookup columns and even that will not work most of the time.

     

    Have you tried to connect via Sharepoint.Contents ?