How to Change Table to Import Mode in Power BI

Nothing is more frustrating than a Power BI report that takes forever to load. You've built slick visuals and powerful measures, but when every slicer click means a 30-second wait time, your stakeholders start to lose patience. Often, the culprit is a table set to DirectQuery mode when it should be using Import. This article will walk you through exactly how to change a table to Import mode, explaining what storage modes are and why this simple switch can dramatically speed up your report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Does Power BI Have Different Storage Modes Anyway?

Before we jump into the "how," it's helpful to understand the "why." Power BI offers different storage modes to give you flexibility in how you handle data, balancing performance against data freshness and size. Think of it like a researcher borrowing books from a library. You can either check the book out (Import) or look things up in the library's live catalog as you need them (DirectQuery).

1. Import Mode

In Import mode, Power BI pulls a full copy of your data from the source and stores it inside the .PBIX file itself. This is like checking the book out of the library and taking it home with you.

• Pros: A lightning-fast experience for the end-user. Because the data is compressed and cached in memory, slicing, dicing, and filtering visuals is incredibly responsive. You also get access to the full power of DAX functions without limitations.
• Cons: The data is only as fresh as the last refresh. You will need to schedule a refresh to get updated data. Additionally, since the data is stored in your file, it increases the file size and is subject to dataset size limits (e.g., 1 GB for Power BI Pro).

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. DirectQuery Mode

In DirectQuery mode, Power BI does not store a copy of the data. Instead, it only stores the metadata (table names, column names, relationships). When a user interacts with a visual, Power BI sends a live query back to the original data source to fetch the required information. This is like using the library's real-time catalog, your request goes directly to the source of truth.

• Pros: The data in your report is always up-to-date, making it perfect for real-time or near-real-time analytics. You can also work with massive datasets that would be too big to import into Power BI.
• Cons: Performance can be slow. The responsiveness of your report is entirely dependent on the speed of the underlying data source. Every click sends a new query, which can lead to lag. There are also some significant limitations on the DAX functions you can use.

3. Dual Mode

Dual mode offers the best of both worlds. A table in Dual mode can act as either Import or DirectQuery depending on what the report needs. Power BI intelligently decides which mode to use for each visual, optimizing performance. This mode is mainly used for dimension tables (like a Products or Customers table) that interact with massive DirectQuery fact tables (like a giant Sales transaction table).

Which Mode Should You Use?

Here’s a simple rule of thumb:

• Use Import for most tables, especially dimension tables or fact tables that are small to medium-sized (under a few million rows). This will give your users the best and fastest experience.
• Use DirectQuery only when you have a truly massive dataset (think billions of rows) that won't fit in memory, or when you have a critical need for real-time data that cannot be met with a scheduled refresh.

Many slow reports are caused by using DirectQuery for tables that could and should have been imported. Let’s fix that.

How to Change Your Table's Storage Mode to Import

Switching a table's storage mode is straightforward, but you have to do it in the right place. You won't find this option in the Power Query Editor, you need to be in Power BI Desktop's main window.

Graphed

Still Building Reports Manually?

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

Watch the Demo

The Step-by-Step Process in Model View

The clearest and most visual way to manage storage modes for all your tables is in the Model view.

1. Open Your Report in Power BI Desktop: Start by opening the .PBIX file you want to edit.
2. Go to Model View: On the left-hand side of the screen, click on the icon that looks like three connected boxes. This is the Model view, where you see your data model relationships.
3. Select the Table: Find the table you want to change in the visual diagram and click on its title bar to select it.
4. Open the Properties Pane: If it's not already visible, go to the "View" tab in the top ribbon and make sure the "Properties" checkbox is ticked. This pane usually appears on the right side of the screen.
5. Find the Advanced Section: In the Properties pane, scroll down until you find the "Advanced" section and expand it if it's collapsed.
6. Click the Storage Mode Dropdown: The very first option here will be "Storage mode." Click the dropdown menu next to it.
7. Choose "Import": From the list of options (DirectQuery, Import, Dual), select "Import."
8. Confirm the Change: Power BI will likely show a warning message explaining that this change may require deleting data from other tables or will take time to process. This is normal. Click "OK" to proceed.

Power BI will now start loading a full copy of that table's data into your model. Depending on the size of the table and your connection speed, this could take a few seconds or several minutes. Once finished, save your report. Your visuals that rely on this table should now be much, much faster.

Important Considerations and Troubleshooting

While the process is simple, there are a few things to keep in mind that might catch you off guard.

What if the "Storage mode" Option is Grayed Out?

This is a common issue. If you can’t click the storage mode dropdown, it's almost always because of its relationship with another table. In a composite model (a model with mixed storage modes), Power BI has rules:

• An Import table cannot have a relationship with a DirectQuery table on the "one" side of a one-to-many relationship.
• You might have dependencies locking you in. In many cases, you have to change a group of related tables all at once.

If your option is grayed out, check the relationships of that table. You may need to change the storage mode of a related table first before Power BI will allow you to change the one you originally intended.

Remember to Set Up a Data Refresh

The biggest trade-off of moving to Import mode is that your data is now static. It won't update automatically. After you publish your report to the Power BI service, you must configure a scheduled refresh. For a Pro license, you can schedule up to 8 automated refreshes per day, which is sufficient for most business reporting needs.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Impact on Report Publishing and File Size

Switching tables to Import mode will increase the size of your .PBIX file. If you're importing several tables with millions of rows, be mindful of dataset size limits. The VertiPaq engine that Power BI uses is excellent at compression, but it's not magic. Keep an eye on your file size, especially if you have a Pro license, to avoid publishing failures.

Final Thoughts

Switching a Power BI table from DirectQuery to Import mode is one of the most effective ways to solve performance issues and create a responsive user experience. By understanding the trade-offs between speed and data freshness, you can build smarter, more efficient reports that your team will actually enjoy using.

Digging through properties panes, managing data models, and setting up refresh schedules highlights just how much technical expertise is often needed to get simple answers from your data. At Graphed, we built our tool because we believe data analysis shouldn't require that level of specialized BI knowledge. We connect directly to your sources - from Google Analytics to Shopify to Salesforce - and allow you to build live dashboards in seconds by just describing what you want to see. Instead of wrestling with storage modes to get faster performance, you can simply ask, "show me my revenue vs ad spend for the last 30 days," and instantly get an interactive chart.