Forum Discussion
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 button.
I tried this step, after going through different threads.
and then this step
After clicking "OK", I get this again with no "expand " button.
What I am doing wrong?
How can I get a single value from this "List"
My List data has values like this (exported my sharepoint list to excel)
ABC;#12
DEF;#45
.....
and I want values before ; i.e ABC, DEF
I saw some posts using M code, ut couldn't understand
Please help....
Thanks for you help......
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