Power BI parameters: one value that many queries can reuse
Power BI parameters are named values in Power Query that a query can reuse, such as a server name, a file path or a start date. Change the value once, and every query that uses it follows. So moving a report from a test database to production takes one edit. This guide shows how to create, use and update them.
- One value, many queries
- Created in Desktop
- Editable after publishing
Last updated
What are Power BI parameters?
A parameter stores a value under a name. Microsoft Learn describes it as an easy way to store and manage a value that you can reuse. Queries then refer to the name instead of a typed value.
They serve two main jobs. First, a parameter can feed a step, for example the value in a filter. Second, it can act as the input of a custom function. Both uses keep logic in one place.
Do not confuse them with field parameters. Those belong to the report layer and let readers swap the measure or column in a visual. The values in this guide live in Power Query and shape how data loads.
How to create Power BI parameters in Power Query
Open the Power Query editor from Desktop first, since that is where authors create them.
Open Manage Parameters
First, go to the Home tab and select Manage Parameters. Then choose New Parameter from its menu.
Name and describe it
Then enter a clear name and a description, so the next author knows its purpose.
Set type and values
Next, choose the data type and the suggested values. Enter a current value as well.
Use it in a step
Finally, open a step such as Filter Rows and pick Parameter instead of a typed value.
Properties to set when you define a query value
The Manage Parameters dialog asks for these properties. A few minutes here saves confusion later.
| Property | What it does | Practical tip |
|---|---|---|
| Name | Identifies the value in queries | Use a plain name, such as ServerName |
| Description | Explains the purpose to other authors | Say which queries depend on it |
| Required | Marks whether a value must exist | Keep it on for connection values |
| Type | Sets the data type of the value | Match the type of the column you filter |
| Suggested values | Any value, a list of values or a query | Use a list to prevent typing mistakes |
| Current value | The value queries use now | Check it before you publish |
How do you change Power BI parameters after publishing?
Authors create them in Desktop, but the service lets you edit their values. Microsoft Learn gives the path: select the Settings cog, open Settings, go to the Semantic models tab and pick the model. Then expand the Parameters section.
That matters for deployment. For example, a test workspace can point at a test database and production at the live one. The report file stays the same, while only the value differs.
Some fields appear gray. Microsoft notes that values of type Any or Binary do not work in the service. So choose a specific type, such as Text or Date, when you expect to edit a value online. Refresh the model after a change, so the data reflects the new value.
Which jobs suit a stored query value, and which do not?
Connection details are the classic case. Server names, database names and folder paths change between environments. With a stored value, one edit redirects every query.
Filters are the second case. A start date can limit how much history loads during development, so refreshes stay quick. Incremental refresh also relies on two date values of this kind, which the service then manages.
They are not a reader control, however. A person viewing a report cannot change a Power Query value from the page. For reader choices, use slicers or field parameters instead. Templates are another option, since a template file asks for values when someone opens it.
Reusable query value questions from report authors
Can readers change Power BI parameters in a report?
No. These values belong to Power Query, so they take effect when data loads, not when a reader clicks. Someone with access to the settings of the model changes them, and a refresh follows. If readers need to choose what they see, build slicers or field parameters. Microsoft also documents dynamic M query parameters for certain DirectQuery sources, which is a separate feature.
Why are my Power BI parameters grayed out in the service?
The service cannot edit every type. Microsoft states that the types Any and Binary do not work there. Open the file in Desktop, set a specific type such as Text, Decimal Number or Date, and publish again. After that, the value appears as an editable field under Parameters in the semantic model settings.
What is the Always allow option?
It is a check box on the View tab of the Power Query editor, in the Parameters group. With it on, step dialogs always offer a parameter as an input, even before one exists. That saves a trip back to the Manage Parameters dialog. It is a convenience for authors and changes nothing about how the model behaves.
Can one of these values hold several entries?
In Desktop it holds one value at a time. Microsoft notes that list versions with several values exist only in Power Query Online. However, the suggested values can come from a list or a query, so authors pick from valid options. For a filter on many values, a separate list query usually works better.
Can you tidy up our Power Query setup?
Yes. Power BI Agency reviews queries, replaces typed connection details with reusable values and documents the result. The work happens online in your own Microsoft tenant, with weekly demos. Our team is small and experienced, part of Sataware Technologies, a Microsoft Solutions Partner, and not part of Microsoft. Call (480) 485-7373 or ask for the free 30-minute assessment.
Let's build your first dashboard together.
Tell us what you report on today. A consultant replies within 2 hours with next steps.
Trusted partners
Microsoft Solutions Partner · AWS Partner
Cloud & AI Platforms
Azure SQL, Microsoft Fabric and the data pipelines behind your reports.
AI Business Solutions
Power BI reporting on your Dynamics 365, Business Central and Power Platform data.
Security
Row-level security and Entra ID sign-in on every report and workspace.
Amazon Web Services
Power BI on your AWS data, with connectors for Redshift, Athena and S3.