Reply
aspitalnick
Frequent Visitor

Help getting data out of a sharepoint list

I am accessing a Sharepoint list with PowerBi and the fields that have dropdown lists show up as [list]. If tried multiple methods to extra the single result in PowerBi but to no vail. The field is called Sub Chosen. If I click on the word [list] in Power Query is shows the attached informationPowerBi.PNG

sub_list.PNG

1 ACCEPTED SOLUTION
KNP
Super User
Super User

Ok, so if you delete the step that was created when you clicked on the word in the list, do you see this icon in the column header for that column?

KNP_0-1664492717211.png

 

If you do, click on that and choose either 'Expand to New Rows' or 'Extract Values...'

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

View solution in original post

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @aspitalnick 

 

If every list has only single value, you can add a custom column to extract this value. Use List.First([Sub chosen]). Then delete the List column [Sub chosen].

vjingzhang_0-1664526008614.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

KNP
Super User
Super User

Ok, so if you delete the step that was created when you clicked on the word in the list, do you see this icon in the column header for that column?

KNP_0-1664492717211.png

 

If you do, click on that and choose either 'Expand to New Rows' or 'Extract Values...'

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

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