Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have an issue expanding the list values inside the power query. I'm not getting the two small arrows to expand the column as we usually do. any idea how to resolve it?
Thanks
Solved! Go to Solution.
NewStep=Table.TransformColumns(PreviousStepName,{"Column1",each if _ is list then _ else {_}})
Right click and choose, To Table...
You'll then be able to work with it.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Hi KNP,
That is the problem, When I convert it to the table. Still, I don't get an option to expand columns
Thanks
NewStep=Table.TransformColumns(PreviousStepName,{"Column1",each if _ is list then _ else {_}})
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |