Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
61 | |
46 | |
45 |