How to Edit Dataflow in Power BI

Your Power BI dataflow is running smoothly, but now a key business requirement has changed. Maybe you need to add a new column, filter out a different product category, or update the location of a source file. This article will show you exactly how to edit your existing dataflows, giving you full control over your data transformation process directly within the Power BI service.

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 is a Power BI Dataflow?

Before we jump into editing, let's quickly revisit what a dataflow is and why it's so powerful. Think of a Power BI dataflow as a reusable, cloud-based data preparation process. Using the familiar Power Query interface, you can connect to various data sources (like SharePoint, SQL databases, or web APIs), clean, transform, and reshape that data, and then load it into a managed storage location in Azure.

The magic is in its reusability. Once created, a single dataflow can be the trusted source of clean, prepped data for multiple Power BI datasets, reports, and dashboards. This centralization means that instead of repeating the same data cleaning steps in every single report, you do it once in the dataflow. Editing that one dataflow updates the logic for every single report connected to it, saving you an incredible amount of time and ensuring consistency.

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

Finding and Opening Your Dataflow for Editing

First things first, you need to navigate to your dataflow within the Power BI service (the browser-based version of Power BI). You cannot edit dataflows from the Power BI Desktop application.

Here's how to get there:

1. Log into your Power BI account at app.powerbi.com.
2. From the navigation pane on the left, select the Workspace where your dataflow is located.
3. Inside the workspace, you'll see tabs for your different Power BI assets (All, Content, Datasets + dataflows, etc.). Find and click on your target dataflow. It will be identified by a specific dataflow icon.
4. Hover over the dataflow's name and you'll see a few options appear. Click the ellipsis (...), which means "More options."
5. From the dropdown menu, select Edit.

This action will launch the Power Query Online editor in a new window, which is the command center for all your dataflow modifications.

Navigating the Power Query Online Editor

If you've ever used Power Query in Power BI Desktop or Excel, this screen will look very familiar. It's intentionally designed for a consistent user experience. If you're new to it, here's a quick layout of the key areas:

• Queries Pane (Left): This area lists all the tables (or queries) within your dataflow. You can select a query here to see its data and transformation steps.
• Data Preview (Center): This is the main window where you see a preview of your data at the currently selected step. It allows you to see the immediate result of your transformations.
• Applied Steps Pane (Right): This is arguably the most important section for editing. It lists, in order, every single transformation that has been applied to your data, from the initial source connection to the final output. This chronological list is the recipe for your data cleanup, and it's what we'll be modifying.
• The Ribbon (Top): Just like other Microsoft products, the ribbon across the top contains all the tools and functions you can use to transform your data. It's organized into tabs like Home, Transform, and Add Column.

Common Dataflow Edits and How to Make Them

Now, let's get into the practical, day-to-day edits you're likely to perform on your dataflows.

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

1. Modifying an Existing Transformation Step

Let's say you previously filtered your sales data to only show results for "USA," but now you need to include "Canada" as well. This involves changing an existing step.

Steps:

1. In the Queries pane, select the table you want to edit.
2. In the Applied Steps pane, find the step that performs the filter. It's often named something like "Filtered Rows" by default (this is why renaming your steps is a great practice!).
3. Click on the step to select it. You'll see the data preview in the center revert to how it looked just before that step was applied.
4. Next to the step name, click the small gear icon (⚙️). This opens the configuration window for that specific step.
5. In the filter dialog box, you can now modify the criteria. For instance, you could change the filter from "equals 'USA'" to "is one of 'USA', 'Canada'".
6. Click OK. The data preview will refresh to show the result of your modified step.

2. Adding a New Transformation Step

Imagine your source data now includes a full name column, but you need separate columns for first name and last name. This requires adding a new step.

Steps:

1. First, in the Applied Steps pane, make sure you have the last step in the list selected. This ensures your new transformation is added to the end of the sequence.
2. In the data preview, find and select the "Full Name" column.
3. Navigate to the Transform tab in the ribbon.
4. Click the Split Column button and choose your method, such as "By Delimiter."
5. In the pop-up, choose "Space" as the delimiter and elect to split at the "left-most delimiter."
6. Click OK. Power Query will generate two new columns. You'll also see that a new step, something like "Split Column by Delimiter," has been added to the bottom of your "Applied Steps" list. You can now rename the new columns for clarity (which itself will add another new step).

3. Reordering or Deleting Steps

The Applied Steps list is a sequence. Sometimes, you need to change that order or remove a step that's no longer necessary.

• To Reorder: Drag and drop steps in the list to change their order. Be cautious—reordering steps can break your query if a later step depends on a column or calculation from an earlier step that you've moved.
• To Delete: Click the 'X' next to the step's name in the Applied Steps list. Power BI will warn you that this could break subsequent steps. For example, if you delete a step where you created a new column, any later steps that reference that column will fail.

4. Changing the Data Source Path

This is a frequent need. An Excel file or CSV used as a source moves, or a server name changes.

Steps:

1. In the Applied Steps pane, click on the very first step, usually named Source.
2. Click the gear icon (⚙️) associated with the Source step.
3. This opens a dialog box showing connection details (like URL or server info).
4. Update the file path, URL, or server information.
5. Click OK. Power BI will attempt to connect to the new source using the stored credentials.

Saving and Refreshing Your Dataflow

Once you're satisfied with your changes:

1. In the bottom right corner of the editor, click the Save & Close button.
2. Power BI will validate your query logic. If no errors, it saves the dataflow structure. Note: this only saves the transformation logic, not the data.
3. Return to your Power BI workspace. You’ll see a small spinning refresh icon next to your dataflow name. Hover over it—if it says "Validating," wait for completion.
4. To refresh the data with your new rules, hover over the dataflow and click the Refresh now icon (circular arrow).

This process will pull data from sources, apply your transformations, and load it into storage. Once complete, all connected reports will access the updated data.

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

Best Practices for Editing Dataflows

• Name Your Steps: Avoid default names like "Filtered Rows1." Rename steps descriptively (e.g., "Filter for Active Customers") for clarity.
• Consider Downstream Impacts: Before deleting or changing columns, think about how it affects reports relying on that data.
• Add Comments: Right-click steps and select "Properties" to add descriptions explaining the purpose of each transformation.

Final Thoughts

Editing a Power BI dataflow is straightforward and empowers you to maintain a centralized, consistent data transformation process. Using the Power Query Online editor, you can modify steps, add new transformations, or update data sources to keep your data models aligned with evolving business requirements.

Of course, mastering tools like Power BI takes time, involving learning curves around interfaces, data modeling, and query languages. At Graphed, we've taken a different approach. We built an AI data analyst that connects your marketing and sales sources—like Google Analytics, Shopify, Facebook Ads, and Salesforce—and enables you to create real-time dashboards and reports simply by asking questions in plain English. Instead of manual workflows, just ask, "Show me my top-performing ad campaigns by revenue last month," and get an instant interactive dashboard—no setup or endless clicking needed.