Forum Discussion
Anonymous
2 years agoNot applicable
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...
- 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 ?
lbendlin
2 years agoSuper User
A document library with lookup columns? What's the reason for that?
- Anonymous2 years agoNot applicable
Part of a document management system, so person columns, lookups to other lists, etc.
- lbendlin2 years agoSuper User
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 ?