Reuse query steps in a Excel file

[mattfq]

Good morning!

I'm a new user of PowerBi in my company and monthly I have a task of produce graphs of a excel file.

My problem is:

I have to do, monthly, many (almost 500) steps to make some names get default values, like "CPU Load Average 15" to "CPU Load Average". Can I copy and past steps from another file?

Example of what I'm doing: http://prnt.sc/ef4hss

[Anonymous]

Hi @mattfq,

>>I have to do, monthly, many (almost 500) steps to make some names get default values, like "CPU Load Average 15" to "CPU Load Average". Can I copy and past steps from another file?

If these file has the same struct and column, you can copy steps from advanced editor. In my opinion, I'd like to suggest you create a custom function to deal with the same process steps.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi mattfq

Are the names in columns or rows?

Greetings Hp Pfister