Forum Discussion
Power Bi filtering with multi lookup columns
Microsoft EmployeeHi Someguy154,
That you mentioned about "multi lookup columns", "list" and "Objects" are all supported items in SharePoint site, however, they are not supported in Power BI. To establish relationships between these tables, you should first expand data to convert table to supported structure in desktop.
So, please show us the final table views, including table structure and sample data rows, and illustrate your requirement with examples to help us better understand.
Regards,
Yuliana Gu
Sure, no problem. I hope I understood you correctly, otherwise just tell me what else you need.
My requirement is simply that the Which and Why tables react properly when you filter the tables with the slicers on the left. If I select a person, I want to see all the Data Objects, shown in the Which table, that are related to that person. Suppose we click on a person in the Person slicer, I want the Which table to show only the objects we have on that person. The objects are in a multi lookup column in SharePoint.
When you say that I should expand data to convert tables to the supported structure, what does that mean?
The way the site is structured, we have a main Consensts list, with lookups to Systems, Data Subjects and Data Objects. Since the Systems and Data Subjects lookups are regular Lookups, I get the PersonID and SystemID values that I can use to connect them with the ID of the Consents. But the Data Objects don't have any such values, so I'm just using the IDs of both lists directly.