Create the parameters What if we want to change these values or file paths? Obviously we could edit the query each time, which would be very time-consuming. Or we could create parameters. As a simple explanation, a parameter is just a normal query, in which we drill down into the value itself and load as a connection. In this example, we will be using an Excel Table as the source, but it could equally be in named range, CSV, or any other data source we can get into Power Query. And also we can u