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 peo...
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).