- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 07-03-2024 03:42 PM | ||
06-28-2024 05:52 AM | |||
07-24-2023 03:43 PM | |||
07-01-2024 05:32 PM | |||
03-14-2024 12:12 PM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |