Expand columns with values and nested tables in Power Query

Have you tried to expand tables on columns that have both values and nested tables but the double arrow is missing? Here is how to do it when that happens :)

Join this channel membership to get access to all the recorded bites as they become available:

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen

#CURBAL #SUBSCRIBE

[MitsorugiHiten]

I love you ❤❤ you’ve been an international treasure in the world of Power BI.

[krutch]

I can't thank you enough for this!! I couldn't get any other method to work.

[Picla_Peremohy]

Your training and explanations are the absolute best. Thank you

[alexeyboboev]

This is exactly I was looking for! Thanks!

[andrewheriot]

Fantastic! Solved my problem! Thankyou.

[stanst]

Thanks for this hint, tried to resolve it from power query, looks like every power query line can be produced using gui

[Lixia]

I am going to try this, it made me so headache before. Thanks !

[baskis]

Power query es mágico¡¡ Gracias por compartir¡¡