Forum Discussion
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 loo...
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 ?
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.