Forum Discussion

Copper Contributor

Jul 18, 2019

Power query template

Hi everybody, We're looking to make a power query template. We want to apply the same query to different sources. For example: in our projects we receive our data in excel files we need to an...

BI & Data Analysis

Power Query

nabilmourad

MVP

Jul 18, 2019

Klara_

You need to create the first Query to fix one File. Then Duplicate it and save it as a Function (to be available to run on any other file and redoing the same steps)

There are many YouTube tutorials for doing this, I recommend ExcelIsFun by Mike Girvin (Famous Excel MVP)

Here is an example

https://www.youtube.com/watch?v=_csX8sCzJd0

Hope that helps

Nabil Mourad