How to import MS List with multiple select drop-downs

[Anonymous]

Hi,

I have a list that I am importing to a Power BI Report. Some of the fields in the list are multiple select dropdowns. When I import this into Power BI I need to 'Expand' or 'Aggregate' the data in order to see it I think. However, when I expand the list it duplicates each line. I need to have one row with the options seperated by a comma.

Screenshot1: Snip from the Microsoft List where we have 6 industries selected.

Snip from Power BI where you can see that this translates to 6 rows.

Thanks in advance if anyone can help!

Robbie

[Anonymous]

Hi,

Thanks so much for replying!

What I would like to see is 1 row, and all of the data contained in one column (just like the power app screen grab above).

So it would show as "Finance,Government,Healthcare,etc".

Is that possible do you know?

Thanks!

[Anonymous]

Hi @Anonymous ，

Yes, you can create a custom column to merge this columns

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

Hi @Anonymous ,

I'm not sure I have understood what you want to achieve. 

Are you expecting these six rowss to become one row , something like this result?

Or what you want is some other results？

If I have misunderstood you, be sure to let me know promptly. If it is convenient for you, you can show me the expected result you want, it will help me a lot to help you solve the problem.

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi,

Thanks , this was helpful. In the end my approach was as follows:

- Import data into multiple rows.

- Create a new table using SUMMARIZE function, and then use CONCATENATEX to pull the values into one row.

Slightly diff approach but same result 🙂