Dynamically Expand All Columns from Multiple Tables in Power Query

- - - - My Other Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog + Download - - - -

[subjectb]

This is precisely what I've been looking for! Chandeep, you are the man!

[michaelbrandel]

My god, this is really awesome! I never thought there is such an elegant method to retain all columns w/o actually knowing them. Thanks so much for sharing this.

[SimX]

Your videos are fantastic, they solve some really unique problems. Really appreciate your posts, learning a lot. Thank You

[ArmandoFrancoCarrillo]

Amazing. You answered all my questions step by step. Great video. Thanks.

[ferdinandsantos]

I just had the same issue that was resolved by your solution. Thank you so much for sharing!

[marshal]

Nice video. In my case, I would usually insert the [Name] into the [Data] before using Table.Combine like below
InsertName =Table.AddColumn(PrevStep, "Data2", each Table.AddColumn([Data], "Name", (x) => [Name]))
Combined =Table.Combine( InsertName[Data2] )
Using this technique, you can even insert multiple columns beforehand like below
InsertNameKind =Table.AddColumn(PrevStep, "Data2", each Table.AddColumn([Data], "Name", (x) => [[Name], [Kind]]))
This time, a list of record will be inserted and after using Table.Combine, you'll have to expand the record to pull both [Name] and [Kind].
Cheers

[pravinshingadia]

Absolutely love your videos. You cover really great ideas to constantly improve our skills - thank you!

[policani]

Thank you so much! I've been struggling for months trying to figure out how to do what you showed us starting at the 2:50 mark within your video. Who knew it was as simple as clicking on the gear icon! I was trying to write in the query and it was failing each time I refresh my data.

[SMITDEDHIA]

This video should be a ready reference for all those starting to use Power Query almost everyday. Thank you!!
Because the UI of PowerQuery is so good, some of us normally don't go beyond the functions mentioned in Home, Transform & Add Column Tab.

[tug_van_tuggles]

Wow. That is so cool. Power Query is saving our trial teams at work so much time, but giving me more work setting them up LOL. I can see myself using this some time in the future. Thanks so much

[anilb]

Very useful.. Thank you very much you made my life easy ... Appreciated !!

[aaron]

This was the best thing I've ever seen/read on pq. So helpful! Many thanks!

[emilmubarakshin]

fantastic video on so many levels! Cheers!

[GosCee]

Chandeep, your videos are amazing; your teachings are excellent; you are doing an awesome job . . . thank you for sharing your knowledge in such an impactful way.

[khalidmajeed]

sir to promote all your effort in will be great work for urdu

[jessiecao]

Love your videos, very logic and easy to understand, will absolutely watch all the related videos one by one

[vli]

Awesome ! Very useful one when loading data from folder or files as well.
Table.Combine step should be followed after promoted headers even in case of single data source.
Thank you Chandeep @Goodly for sharing your knowledge for the benefit of everyone here !

[ndatta]

Your videos have been immensely beneficial. In this particular video, you've provided valuable insights on how to include all columns by default in Power Query. I'm curious to know if there is a method for customizing the default column data types individually?

[wayneedmondson]

Hi Chandeep. Nice one.. very clever! Thanks for sharing these techniques. Will study them with great interest. Thumbs up!!

[vasilisa]

Thank you very much. This video helped me a lot.