Forum Discussion
Using data from SharePoint list that contains a list selection column
Here is a good article on the subject:
https://powerbi.microsoft.com/en-us/blog/how-to-expand-a-list-of-records-in-a-query/
When connecting to a SharePoint list, the values in a column that allows multiple selection will appear as "lists". Some other types of columns can also contain "records".
These can be expanded in the Power Query editor.
Here is a Power BI table queried from a SharePoint List where the column Image Type allows multiple selection, but I did not expand it:
If I expand this column in the Power Query editor by clicking the expand icon to the right of the column name, then Expand to New Rows (for example), I end up with this:
Hopefully that helps!
Regards
Here is a good article on the subject:
https://powerbi.microsoft.com/en-us/blog/how-to-expand-a-list-of-records-in-a-query/
When connecting to a SharePoint list, the values in a column that allows multiple selection will appear as "lists". Some other types of columns can also contain "records".
These can be expanded in the Power Query editor.
Here is a Power BI table queried from a SharePoint List where the column Image Type allows multiple selection, but I did not expand it:
If I expand this column in the Power Query editor by clicking the expand icon to the right of the column name, then Expand to New Rows (for example), I end up with this:
Hopefully that helps!
Regards
Thank you!
