How to Rename a Table in Power BI

Giving your tables clear, understandable names in Power BI is a small step that makes a huge difference in your reports. Getting rid of generic names like "Table1" or cryptic source file names makes your data model easier to read, your formulas simpler to write, and your final reports more professional. This guide will walk you through three different methods for renaming tables in Power BI, explaining the pros and cons of each, plus some best practices to follow.

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

Why Bother Renaming Your Tables?

You might be tempted to just load your data and start building visuals, but taking a moment to rename your tables pays off significantly. Here’s why it’s a critical habit for any Power BI user:

• Improves Clarity: Which is easier to understand, fct_SLS_export_v3 or SalesData? Clear names tell you exactly what data the table contains without making you guess. This is especially important when sharing your report or returning to it months later.
• Simplifies DAX Formulas: Writing DAX measures is much easier with clean table names. Compare SUM('SalesData'[Revenue]) to SUM('Table1_from_source_a'[Column_4_rev]). The first is intuitive and instantly readable, while the second requires you to cross-reference what each part means, increasing the chance of errors.
• Streamlines Relationship Management: When you're in the Model view trying to connect tables, having clear names like FactSales and DimCustomer makes it obvious which tables and columns should be related.
• Speeds Up Report Building: As you drag and drop fields into your report canvas, you'll know exactly which table each field is coming from, making a faster and more intuitive report design process.

In short, proper naming is the foundation of a clean, efficient, and scalable Power BI report.

Method 1: Rename a Table Directly from the Fields Pane

This is the quickest and most straightforward way to change a table name directly within the main Power BI Desktop interface. It’s perfect for fast cosmetic updates.

Follow these steps:

1. On the right side of your screen, find the Fields pane. This lists all the tables and columns in your data model.
2. Locate the table you want to rename in the list.
3. Right-click on the table name. A context menu will appear.
4. Select Rename from the menu. The table name will become an editable text field.
5. Type in your desired new name and press Enter to confirm.

You can also double-click the table name slowly to make it editable, just like renaming a file in Windows.

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

When to Use This Method

This approach is excellent for quick, on-the-fly changes, especially when you’ve just loaded data. If you’ve imported an Excel sheet named "Sheet1," a 10-second rename in the Fields pane can immediately add clarity.

Potential Pitfall

It's important to understand that this method only changes the display name (or alias) of the table within the Power BI report view. The original name of the query in the Power Query Editor remains unchanged. This can sometimes lead to confusion, as you'll see one name in your report and a different name in the data transformation layer.

Method 2: Rename a Table in the Data View

Another way to achieve the same result as the first method is by renaming the table from the Data (or Table) view. This is purely a matter of personal preference, as the underlying action is identical to renaming in the Fields pane.

Here’s how to do it:

1. On the far left navigation bar of Power BI Desktop, click on the icon for the Data view (it looks like a small grid or table).
2. Once you're in the Data view, the Fields pane will still be visible on the right.
3. Just like in the first method, double-click or right-click the name of the table you wish to change in the Fields pane.
4. Select Rename, type the new name, and press Enter.

This simply provides another context to perform the exact same action. The results and potential pitfalls are identical to Method 1, it changes the alias in the report model but doesn't affect the Power Query name.

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

Method 3: Rename a Table in the Power Query Editor (The Best Practice)

For consistency and best practices, the most robust way to rename a table is within the Power Query Editor. Power Query is the engine that handles all data transformation in Power BI, and renaming the query here changes the name at the source level of your model. This eliminates any potential confusion between the transformation layer and the report layer.

Here is the recommended step-by-step process:

Step 1: Open the Power Query Editor

In the Power BI Desktop main window, navigate to the Home tab on the top ribbon and click the Transform data button. This will launch a new window for the Power Query Editor.

Step 2: Locate the Query to Rename

On the left side of the Power Query Editor, you’ll see a Queries pane that lists all of your tables. Find the one you need to rename.

Step 3: Rename the Query

You have two ways to do this:

• Option A (Recommended): Click once on the query you want to rename. On the right side, you'll see the Query Settings pane. Under the Properties section, there is a field labeled Name. Simply highlight the text in this box, type your new table name, and press Enter.
• Option B: Alternatively, you can right-click the query name in the left-hand Queries pane and select Rename from the context menu.

Option A is generally better because it keeps all your main query adjustments (like the name and description) consolidated in one visible location.

Step 4: Apply Your Changes

This is the most important step! After renaming your query, you must apply the changes back to your Power BI data model. In the top-left corner of the Power Query Editor window, click the Close & Apply button. Power Query will close, and Power BI will update your data model with the new table name.

By using this method, the name of your table will now be consistent everywhere - in the Power Query Editor, the Fields pane, your DAX formulas, and the Model view.

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 Naming Your Power BI Tables

Getting the mechanics right is half the battle, the other half is using a good naming convention. Here are some actionable tips:

• Use Descriptive Names: Choose names that clearly represent the data inside. CustomerDetails, SalesTransactions, and Products are far superior to Table1, Import_April, or Query-final.
• Stay Consistent: Pick a casing style and stick with it. PascalCase (SalesData) is common and very readable. Whatever you choose, apply it across all your tables.
• Avoid Spaces and Special Characters: While Power BI can handle table names with spaces, it forces you to wrap them in single quotes in your DAX formulas (e.g., 'Sales Data'[Revenue]). Avoiding spaces by using PascalCase (SalesData) or underscores (Sales_Data) makes for cleaner, more readable formulas.
• Consider Prefixes for Table Types: In more complex models, it can be helpful to prefix your tables to identify their roles. A common practice is:

This practice makes it much easier to navigate and understand your data model at a glance.

Final Thoughts

Renaming tables is a foundational skill in Power BI that promotes clarity and efficiency. You can use the Fields pane for a quick fix, but for robust and maintainable reports, the best practice is to always rename your tables directly in the Power Query Editor. Adopting this habit and pairing it with a consistent naming convention will make your reports significantly easier to build, debug, and share.

While organizing your data model is essential for good reporting, we know that the biggest challenge is often just getting started — connecting scattered data sources and turning them into useful dashboards. It's why we created Graphed . Our platform connects directly to your marketing and sales tools, letting you build real-time, interactive dashboards just by asking questions in plain English. Instead of learning complex software, you can just describe the report you need, and Graphed creates it for you in seconds.