Replication of query tables for multiple sheets with same data sets

[JackOfAllMasterOfNone]

Looking for help in a way to replicate power queries across multiple sheets. I am working on a payroll sheet for my job that tracks money added to checks and money taken from checks. There are seven tables on each sheet that I am pulling data from, to put on one master payroll sheet, so they can easily be entered in to our back office software for payroll.

So question, is there a way to take the power queries from one sheet and apply that formating to all sheets, without having to manually do it for each sheet?

I am tracking tip out to two sets of employees and added tips to five sets of employees.

I then want to append the data so I can make a table to sort by name and date.

 

[severynm]

So question, is there a way to take the power queries from one sheet and apply that formating to all sheets, without having to manually do it for each sheet?

It sounds like you want to replicate the steps of an existing query into a new query. From an existing query, go into the Advanced Editor and copy and paste the code that is there into a new query, changing the Source and Navigation steps as required.

 

[JackOfAllMasterOfNone]

@sererymn Yeah, I figured out how to do it like that. Still is going to take me longer than I'd like, bit will save time.

Curious if there is a way to do it by position on the sheet, since each table I am pulling from is in the same spot on all sheets. In the end I'm just looking for the lazy way I guess, because my time to work on this is limited. The big thing I have to do now for the above mentioned way to work is to name all the tables, since they have random numbers after the names I made on the first sheet I copied over.

Thanks for the reply.

 

[alansidman]

This may be what you are looking to do

Reference vs Duplicate in Power BI; Power Query Back to Basics

Learn the difference between Duplicate and Reference in Power Query in Power BI and Microsoft Fabric through examples

radacad.com