Forum Discussion

Raaz's avatar
Raaz
Helper 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

Raaz's avatar
Raaz
Helper II
5 years ago

Thanks mahoneypat!!!! Your solution worked!!

parithoshp's avatar
parithoshp
New Member
5 years ago

hi Raaz, I'm facing exactly the same issue.. could you please elaborate on the below step suggested by mahoneypat .. I'm still a novice 

Just add a custom column with = [ListColumn]{0}

Thanks