Forum Discussion
Connecting Power BI to SharePoint Online list with more than 12 lookup columns
Dear all,
for consolidating different data sources in a Power BI report I need to connect to a SharePoint Online list, which currently includes more than 12 lookup-table based columns (mainly people picker).
Using the standard SharePoint.Tables connector in Power Query fails due to the general 12-lookup-based-fields-threshold in SharePoint.
Do you have any ideas how to approach this issue? An idea of mine would be to use the same approach as within SharePoint with distinct views only displaying part of the entire list scope and merging the views in Power Query, however, I don't know how to connect Power Query queries to individual views of SharePoint lists. Any ideas on that?
On the other hand: is there a way to connect Power Query to a SharePoint API and directly request individual columns of a list?
Looking forward to your input (even some exhaustive documentation)!
Kind regards
Petter
1 Reply
- The "connect to a specific view" is an option in the menu when you're using the SharePoint list connector. I feel like I tried this when I bumped into it though and it still wouldn't let me connect - if you try it out let me know how it goes for you. I don't know of a way around this other than using text fields for the relationships instead of lookup columns (this becomes more feasible when you're using Power Apps as the front end for the list).
