Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to import MS List with multiple select drop-downs

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

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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 🙂

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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