Understanding query parameters

One of the most valuable features is the ability to define query parameters. We can then use defined query parameters in various cases. For instance, we can create a query referencing a parameter to retrieve data from different datasets, or we can parameterize filter rows. With query parameters, we can parameterize the following:

• Data Source
• Filter Rows
• Keep Rows
• Remove Rows
• Replace Rows

In addition, we can load the parameters’ values into the data model to reference them from measures, calculated columns, calculated tables, and report elements if necessary.

We can easily define a query parameter from Power Query Editor, as follows:

1. Click Manage Parameters.
2. Click New.
3. Enter a name.
4. Type in an informative description that helps the user understand the parameter’s purpose.
5. Checking the Required box makes the parameter mandatory.
6. Select a type from the...