Create a parameter query (Power Query) You may be quite familiar with parameter queries with their use in SQL or Microsoft Query. However Power Query parameters have key differences: Parameters can be used in any query step. In addition to functioning as a data filter, parameters can be used to specify such things as a file path or a server name. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.