- 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
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 information
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
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 ;). |
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. | Proud to be a Super User! |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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].
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
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 ;). |
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. | Proud to be a Super User! |
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
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.
Subject | Author | Posted | |
---|---|---|---|
04-04-2024 07:00 PM | |||
06-28-2024 05:52 AM | |||
03-08-2024 01:42 PM | |||
07-24-2023 03:43 PM | |||
01-09-2024 10:09 AM |
User | Count |
---|---|
18 | |
15 | |
12 | |
8 | |
8 |