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
Icon for Microsoft Employee rankMicrosoft Employee
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
Icon for Helper II rankHelper 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