Query parameters

A query parameter is a value, often read from a named cell of the workbook, that Power Query uses in place of a constant, such as a folder path or a start date. It avoids editing the query when the source changes machine or period. It is read through Excel.CurrentWorkbook().

Example

Source = Excel.CurrentWorkbook(){[Name="ParamChemin"]}[Content]{0}[Column1]

Related concepts

The whole glossary