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!

Need Help
  • 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 ?

4 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    A document library with lookup columns? What's the reason for that?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Part of a document management system, so person columns, lookups to other lists, etc.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        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 ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks, I found that the issue is that using a view will not flatten folders. I am trying a workaround by syncing the data with another list in power automate.