Forum Discussion

Raaz's avatar
Raaz
Icon for Helper II rankHelper II
5 years ago
Solved

Expanding List Type in Power BI

Hi Experts,   In my desktop report,  I have "Sharepoint Online List" connector. One of the columns is of Type "List". When I try to expand it by going through the "Tranform Data", there's no Expand...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    I've seen that before too.  Just add a custom column with = [ListColumn]{0} to extract the first (single item from each list).

    Regards,

    Pat

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Raaz the reason it will not show the arrows to expand because one of the rows doesn't have the value as a list. Having said that the solution mahoneypat proposed will work if every column has list as a value otherwise it will give an error.

 

To overcome the error I will wrap it around "try otherwise" to catch the error, like this

 

 try [ListColumn]{0} otherwise null

 

 

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡