How to Change Parameter in Power BI Service

Making your Power BI reports dynamic is a game-changer, and parameters are the key to doing it. While creating them in Power BI Desktop is straightforward, editing them in Power BI Service - where your end-users actually see the reports - works a bit differently. This article will walk you through exactly how to change parameters directly in the Power BI Service, saving you the steps of re-editing and republishing your report every time you need a new view.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

A Quick Refresher: What Are Power BI Parameters?

Think of parameters as containers for values that can make your reports more flexible and interactive. Instead of hard-coding a value into a filter or calculation, you use a parameter. This allows you, or other users, to easily change that value without having to dig into Power Query or DAX formulas.

They are especially useful for situations like:

• Filtering data: Showing data for a specific sales region, time period, or product category.
• "What if" analysis: Creating slicers to see how a potential future price change or sales volume increase might affect overall revenue.
• Controlling data sources: Using a parameter to switch between a development and a production database server - super useful for testing changes before they go live.

The core benefit is simple: parameters turn a static report into an interactive analytical tool, allowing you to answer different questions from the same dataset without needing to build multiple report versions.

The Key Distinction: Power Query vs. "What If" Parameters

Here’s the nuance that often trips people up: not all parameters are created equal, and not all can be edited in Power BI Service in the same way. There are two primary types of parameters in Power BI, and they behave very differently once published.

1. Power Query (M) Parameters

These are the parameters you create in the Power Query Editor. They are used to transform your data before it's loaded into the report's data model. You might use one to filter the rows of a table being imported or to set the source URL for a web data connection.

These are the parameters you can change in the Power BI Service through the dataset settings. This is because they directly impact the data loading and refresh process for the entire dataset.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

2. "What If" (DAX) Parameters

These are created directly from the report view in Power BI Desktop (under the Modeling tab). When you create a "What if" parameter, Power BI generates a new table using DAX. This table contains a series of values (e.g., numbers from 1 to 100) and is typically used with a slicer on the report canvas. Your end-users interact with this slicer to see how visuals change in real-time.

Because these are designed for on-the-fly interaction within the report itself, they cannot be changed in the dataset settings of Power BI Service. Changing their value is done by simply moving the slicer, not by editing a backend setting.

Understanding this difference is crucial. If you've been searching for a setting to change your "What if" slicer's range in the Service, you won’t find it. This article focuses on editing the first type - Power Query parameters.

Step-by-Step: Changing a Power Query Parameter in the Service

Let's walk through the full process, from creating a parameter in Desktop to editing its value online in the Service. For this example, we’ll create a parameter to filter our sales report to show only the top N products.

Step 1: Create the Parameter in Power BI Desktop

First, you have to create the parameter in the Power BI Desktop application before you can change it online. Power BI Service only lets you edit existing parameters, not create new ones.

1. Open your report in Power BI Desktop and go to the Transform data tab to open the Power Query Editor.
2. In the Home tab of the editor, click Manage Parameters > New Parameter.
3. A new window will appear. Let’s configure our "Top N Products" parameter:
4. Click OK. You'll now see your parameter listed in the Queries pane.

Step 2: Use the Parameter in a Filter

Now, let's apply this parameter to our query to make it dynamic. For this example, imagine you have a Sales table with product sales data.

1. Select your Sales query. Ensure your data is sorted by sales in descending order so the "top" products are at the top.
2. In the Home tab, click Keep Rows > Keep Top Rows.
3. In the dialog box, instead of typing a number like 10, click the small dropdown icon and select Parameter.
4. Choose your TopNProducts parameter from the list and click OK.

You’ll notice that Power Query now filters the table to show just the top 10 products, based on the parameter's current value. Click Close & Apply to return to the main report view.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: Publish Your Report to Power BI Service

With your parameter created and applied, it's time to publish the report.

1. From the Home tab in Power BI Desktop, click Publish.
2. Select the workspace where you want to publish the report.
3. Wait for the confirmation that your report was published successfully.

Step 4: Find and Change the Parameter in Power BI Service

This is where the magic happens. Navigate to your workspace in Power BI Service (https://app.powerbi.com).

1. Find the dataset associated with the report you just published. They will usually have the same name. Click the three dots (...) next to the dataset name and select Settings.
2. In the Settings screen, look for the Parameters section and expand it.
3. You will see your TopNProducts parameter listed, along with its current value (10).
4. Change the value to something else - for instance, 5.
5. Click Apply to save the change.

Note: You’ll need to be an Admin, Member, or Contributor in the workspace to see and change these dataset settings. Viewers cannot change parameters.

Step 5: Refresh the Dataset to See Your Changes

Changing the parameter value doesn't automatically update your report. The new parameter value will only take effect the next time the dataset is refreshed. The report needs to go back to the original data source and re-apply the Top Rows filter with the new value of 5.

1. Navigate back to your workspace.
2. Find your dataset, and click the Refresh now icon. You can also wait for the next scheduled refresh to run if you have one configured.
3. Once the refresh is complete, open your report. Your visuals will now be updated to show data for only the top 5 products.

And that’s it! You've successfully changed a parameter in Power BI Service without touching the original .pbix file.

Real-World Uses for Service-Side Parameters

This functionality isn't just a gimmick, it solves real business challenges by making reports much more manageable.

Managing Database Connections

Perhaps the most powerful use case is managing connections. You can create a parameter for your SQL server name. In Desktop, you can point it to a staging-server. Once you publish the report, you can go into the Service settings and change the parameter’s value to the production-server without having to change any queries and republish.

Source = Sql.Database(ServerNameParameter, "AdventureWorks")

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Controlling Initial Data for Different Audiences

Imagine you have a single sales report used by managers in North America, Europe, and Asia. You can create three copies of the report in the same workspace, each pointing to the same dataset. For each report's underlying dataset copy, you could set a Region parameter to "NA", "EU", or "APAC". This way, when a manager opens their version of the report, it is already filtered for their region by default.

Adjusting Data Refresh Logic

For very large datasets, fetching years' worth of historical data on every refresh is inefficient. You can create a parameter called MonthsToLoad with a value of 12. Your query would then filter the data to only pull the last 12 months. If you ever need to do a one-time historical load of 36 months, you can simply change the parameter value in the service, trigger a refresh, and then change it back for the next scheduled refresh. This saves significant time and processing resources.

Final Thoughts

Changing parameter values directly in the Power BI Service is a powerful feature that separates the report's structure from the data it represents. By creating Power Query parameters in Desktop, you empower yourself and your team to update report filters, data sources, and other essential logic on the fly, without needing to constantly edit and republish the original file.

While Power BI is an effective tool, achieving this sort of flexibility often requires navigating different environments and understanding technical details like Power Query versus DAX. At Graphed, we've designed our platform to remove this complexity entirely. You can connect your marketing and sales data sources in just a few clicks, and then build real-time, dynamic dashboards simply by asking questions in plain English. No more switching between Desktop and Service, no more wrangling settings pages - just describe what you want to see, and let our AI build it for you instantly. If you're ready to get answers from your data in seconds, not hours, come check out Graphed.