Reply
PowerBINoob24
Resolver I
Resolver I

Using data from SharePoint list that contains a list selection column

Good evening.  I'm pulling data from a sharepoint list into my PBI dashboard.  One of the fields in the sharepoint list allows users to select from a list of choices.  When the data is pulled into PBI, PBI just shows [List] as the data in the column.  How do I get PBI to show what the user actually selected?

 

TIA

1 ACCEPTED SOLUTION
OwenAuger
Super User
Super User

Hi @PowerBINoob24 

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:

OwenAuger_0-1712290385265.png

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:

OwenAuger_2-1712290491284.png

OwenAuger_1-1712290487508.png

Hopefully that helps!

Regards


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

2 REPLIES 2
OwenAuger
Super User
Super User

Hi @PowerBINoob24 

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:

OwenAuger_0-1712290385265.png

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:

OwenAuger_2-1712290491284.png

OwenAuger_1-1712290487508.png

Hopefully that helps!

Regards


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Thank you!

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)