From here, you can select what should be the default value for this parameter, which is the default value shown to the user when referencing the parameter.
When this option is selected, a new option called Default Value will be made available. List of values: Provides you with a simple table-like experience so you can define a list of suggested values that you can later select from for the Current Value. Suggested Values: Provides the user with suggestions to select a value for the Current Value from the available options:Īny value: The current value can be any manually entered value. To learn more about the importance of data types, go to Data types. We recommended that you always set up the data type of your parameter. Type: Specifies the data type of the parameter. Required: The checkbox indicates whether subsequent users can specify whether a value for the parameter must be provided. Name: Provide a name for this parameter that lets you easily recognize and differentiate it from other parameters you might create.ĭescription: The description is displayed next to the parameter name when parameter information is displayed, helping users who are specifying the parameter value to understand its purpose and its semantics. Apart from the name of the parameter and the value that it stores, it also has other properties that provide metadata to it. Parameter propertiesĪ parameter stores a value that can be used for transformations in Power Query. Fill in this form, and then select OK to create a new parameter.Īfter creating the parameter, you can always go back to the Manage Parameters window to modify any of your parameters at any moment. Or launch the Manage Parameters window and select New on the top to create a parameter. Using the Manage Parameters window: Select the New Parameter option from the dropdown menu of Manage Parameters in the Home tab. You can also convert a parameter to a query by right-clicking the parameter and then selecting Convert To Query.
Power Query provides two easy ways to create parameters:įrom an existing query: Right-click a query whose value is a simple non-structured constant, such as a date, text, or number, and then select Convert to Parameter. To get to the Manage Parameters window, select the Manage Parameters option inside Manage Parameters in the Home tab.
You can easily manage your parameters inside the Manage Parameters window.