Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Anybody any ideas what is going on here?
Thanks!
Solved! Go to Solution.
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.
A document library with lookup columns? What's the reason for that?
Part of a document management system, so person columns, lookups to other lists, etc.
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 ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.