Issue with empty values for multiple choice SharePoint field

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!