Where is Edit Queries in Power BI?

Trying to find "Edit Queries" in Power BI can feel like a small mystery, especially if you're following an older tutorial or are used to a previous version of the tool. Let’s clear that up right away. The feature you're looking for now lives under a different name: the Power Query Editor, and you can get to it by clicking the "Transform data" button. This article will show you exactly where to find that button and the other quick ways to access the editor so you can get back to shaping your data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Happened to "Edit Queries"? Understanding the Name Change

If you've been working with Power BI or Excel’s power tools for a while, you probably remember the "Edit Queries" button. It was the standard way to launch the editor where all the data magic - cleaning, transforming, and reshaping - happens.

To create a more consistent experience across its products, Microsoft streamlined the naming. "Edit Queries" was renamed to "Transform data" to better describe what the tool actually does. The editor itself was standardized as the Power Query Editor. It’s the same powerful engine, just with new labels on the doors.

This is a frequent point of confusion for both new learners and experienced users returning after a break. You'll still see "Edit Queries" mentioned in forums, blog posts, and video tutorials from just a few years ago. Just remember: when you see "Edit Queries," the modern equivalent is "Transform data."

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Easiest Way to Open the Power Query Editor

The most direct way to access the Power Query Editor is right from the main Power BI Desktop window. You’ll find it on the ribbon at the top of the screen.

Here are the simple steps:

1. Open your Power BI Desktop file (.pbix).
2. Make sure you are on the Home tab of the top ribbon. This is the default tab that opens when you launch the program.
3. Look for a group of tools called Queries. It's usually located between the Data and Insert groups.
4. Within the Queries group, you will see a prominent button labeled "Transform data." This is the button you're looking for!

Clicking "Transform data" will launch a new window: the Power Query Editor. This is the workspace where you can start cleaning and manipulating your data before it's loaded into your Power BI model.

If you click the small dropdown arrow on the "Transform data" button, you'll see two options:

• Transform data: This opens the Power Query Editor so you can work with your existing queries. This is what you'll use 99% of the time.
• Data source settings: This opens a dialog box that allows you to manage the credentials and paths for your data sources. It’s useful if a file location has changed or you need to update a password.

Accessing Power Query When You First Import Data

A crucial time to edit your data is right when you first connect to it. Dirty data loaded directly into your model can cause relationship headaches and inaccurate visuals down the line. Power BI gives you a clear opportunity to jump into Power Query from the very start.

Let's walk through the process:

1. On the Home ribbon, click "Get Data" and choose your data source (e.g., Excel workbook, CSV, SQL Server).
2. Navigate to and select your file or enter your server credentials.
3. The Navigator window will appear. This window shows you the available tables or sheets within your chosen data source.
4. Select the tables you want to import by checking the boxes next to their names.

At the bottom right of the Navigator window, you have two main choices:

• Load: This button loads the data directly into your Power BI data model as-is. You should only choose this option if you are certain your data is perfectly clean and requires no changes.
• Transform Data: This is your friend. Clicking this button opens your selected tables directly in the Power Query Editor, allowing you to clean, filter, and shape the data before it ever hits your model.

As a best practice, you should almost always choose "Transform Data." It’s better to take a quick look at your data in Power Query to check for errors, incorrect data types, or junk columns than to load messy data and have to fix it later.

Alternative Shortcuts to Open the Power Query Editor

While the "Transform data" button on the Home tab is the main entry point, Power BI offers a few other convenient shortcuts to get you into the Power Query Editor quickly.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

1. Right-Clicking a Table in the Data Pane

This is arguably the fastest way to edit a specific query once it's already loaded. The Data Pane (formerly known as the Fields Pane) is the column on the far right of your Power BI Desktop window that lists all your tables and their columns.

• In the main Report View, find the table you want to edit in the Data pane.
• Right-click on the table name.
• A context menu will appear. From this menu, select "Edit query."

This will instantly open the Power Query Editor with that specific query already selected, ready for you to make changes.

2. From the Data View or Model View

Power BI Desktop has three main views, represented by the icons on the left-hand rail:

• Report View: Where you build your visuals.
• Data View: Where you can see your data in a spreadsheet-like grid.
• Model View: Where you manage relationships between your tables.

The "Transform data" button is conveniently available in all three views. If you are inspecting your data in the Data View or organizing relationships in the Model View and spot something that needs to be fixed at the source, you don’t need to switch back to the Report View. Simply look at the Home ribbon at the top of the screen, and you'll find the "Transform data" button waiting for you.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Is the Power Query Editor So Important?

Simply knowing where to find "Edit Queries" is just the start. Understanding why it's such a fundamental part of Power BI will make your reporting more accurate and efficient. The Power Query Editor is your data preparation workshop.

Any changes you make here are recorded as steps and are repeated every time you refresh your data. This means you only have to do the cleaning once. Here’s a summary of what you can do inside the Power Query Editor:

• Cleaning Data: Remove errors, filter out unwanted rows, replace incorrect values, remove duplicate records, and manage nulls.
• Shaping Data: Unpivot columns to turn wide tables into long tables (essential for Power BI), pivot long tables into wide ones, group data to create summaries, and rename columns for clarity.
• Transforming Data: Split a single column into multiple columns (e.g., separating "City, State" into two columns), merge information from multiple columns into one, and change data types (like ensuring a date column is recognized as a date, not text).
• Enriching Data: Add new columns based on conditions (like categorizing sales as "High" or "Low" using a Conditional Column) or merge queries to join data from different sources (like adding customer details from a CRM export to your sales data from an Excel file).

For example, imagine you have a sales report where a date column is formatted as "MM-DD-YYYY" text. In Power BI, this won’t work for time intelligence functions. Inside the Power Query Editor, you can select that column and change its "Data Type" to "Date" with a single click. Every time new data is refreshed, that step will automatically run, ensuring your dates are always formatted correctly.

Final Thoughts

In short, the "Edit Queries" function you might be looking for is now known as the Power Query Editor, which you can easily access via the "Transform data" button on the Home ribbon in Power BI Desktop. It's the central hub for all data preparation, and mastering its capabilities is a crucial step in creating reliable, professional-grade reports.

Manually cleaning and transforming data in Power BI is powerful, but it can be time-consuming, especially for go-to marketing and sales reports needed nearly every day. We designed Graphed to eliminate that entire process. We connect directly to your most important sources like Salesforce, Google Analytics, Shopify, and your ad platforms, handling the data cleaning and connections behind the scenes. Instead of searching menus, you just ask questions in plain English, and Graphed instantly builds the live, auto-updating dashboard for you. This frees your team from data prep to focus solely on the insights that drive growth.