How to Copy & Reuse Transformation Steps on Another Table | Power BI / Power Query Tutorial

How to copy Power Query transformation steps from one table to another table that has the same structure. The Power Query steps that you see on the user interface are actually M language code behind the scenes. The code is accessible thru the Advanced Editor and can be copied to another table/query. The target table or query should have the same or similar structure, otherwise the code will not work unless tweaked. We'll use Zillow Inventory and Sales datasets as an example.
Buy Me a Coffee: www.buymeacoffee.com/johnnycode

[@johnnycode]

If this video save you a bunch of hours, please help me out with a subscribe 😃

[@brahman118]

already did mate before even seeing this comment.

[@TheMissDistortion]

Thanks a lot! You saved me hours of work as I had multiple steps and tables to copy. Your video was to the point and easy to replicate.

[@lorimiller623]

Thank you--this is perfect for pulling in data from different 60-page pdfs!

[@jantraaseth5538]

😀Great tutorial - will save me lots of hours avoiding repetetive tasks! Thanks a million

[@malcbatotony9518]

Thank you so much. This has just saved us a lot of time.

[@FactsBrakeStupidity]

Thank you very much! You're a life saver!

[@EuanM20X]

Thank you! Saved me a good chunk of work

[@philippedemecheleer2381]

Thanks! Saves me a lot of work!

[@user-wq7pt4zm5e]

Saved me so much time. Thank you

[@aleezz1]

wow, that easy, Thank you was going crazy looking for a solution.

[@cindyc6703]

Excellent. Thank a lot. It will save me a lot of work. 😀😀

[@hellmutmatheus2626]

really really really thank you man!!!!

[@mausam114]

This was a life saver for me 😊

[@maxgomez4909]

Straightforward, thanks

[@sergiocely-10]

Great tutorial in just 1 min🔥

[@RafaelAquinoRFA]

Me ajudou demais, tks 🙂

[@ebenezerasare9934]

You saved my life

[@user-he3pd9qi5j]

Muito obrigado!

[@420nace]

Thank you ❤❤❤❤❤❤

[@kamrankalantar8281]

Thank you!

[@chriscasselli9291]

Anyway to do this across hundreds of queries in the same workbook all at the same time?

[@johnnycode]

Unfortunately, no.

[@therickestpicklerick]

Wow!!!!

[@redowblack]

Is there a quicker way to do it for multiple tables? Let's say 30 tables.

[@johnnycode]

Sorry, I don’t think so.

[@ebeneben5472]

i need to reuse with in the same file two different tables identical steps.....

[@johnnycode]

The way that you load your data into Power Query would be different from the video. As long as you can get the 2 tables into Power Query, copying and pasting the transformation steps should work the same as the video. What problems are you encountering?

[@ebeneben5472]

@@johnnycode you are right. I had to pay closer attention.

[@ebeneben5472]

@@johnnycode The errors I would get was that the power query would not preform.