Issue with empty values for multiple choice SharePoint field

[SJW290390]

Hi there

I set up a dataflow to a SharePoint list but I am having issues with extracting values from 2 x multiple choice SharePoint list fields - the rows are empty and it will not allow me to extract the values. Is anyone able to advise me why this is and what I would need to do to fix this issue? Apologies if I have missed anything obvious. I have tried googling this issue but could not find one to match my situation. 

Sam

 

[v-menakakota]

Hi @SJW290390 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-menakakota]

Hi @SJW290390 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-menakakota]

Hi @SJW290390 ,

I wanted to check if you had the opportunity to review the information provided by @grazitti_sapna . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution so other members can easily find it.

Thank you.

[grazitti_sapna · Accepted solution]

Hi @SJW290390 ,

Try below fix,

• Open your Dataflow's Power Query Editor (in Power BI Service or Power BI Desktop, depending on where you're editing).

• Locate the columns that correspond to the multiple choice fields — they will likely be of type List or Record.

• Click the small icon at the top-right of the column header (often looks like two arrows 🔽 or a box with an arrow).

  • If it's a List, you'll choose “Expand to New Rows”.

  • Then, if needed, use another expand step to extract the actual Value field from the resulting records.

If needed you can combine them back to a single row using Text.Combine([YourField], ", ")

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!