How to Switch to Import Mode in Power BI

If you've ever stared at a spinning Power BI loading circle while your patience wears thin, you've likely met the performance limits of its DirectQuery mode. The good news is that you’re not stuck with a slow report. This article will show you exactly how to switch your reporting to Import mode to significantly speed things up and unlock the full analytical power of Power BI.

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

First, What Are Power BI’s Data Connection Modes?

Before making a change, it’s helpful to understand the options available. Power BI primarily connects to your data in two main ways: Import and DirectQuery. They work very differently and are suited for different situations.

Import Mode: The Local Powerhouse

When you use Import mode, Power BI takes a complete copy of your data from the source and loads it into your PBIX file. This data is compressed and stored in memory using Power BI's powerful VertiPaq analysis engine. Think of it as taking a local snapshot of your entire dataset.

• Pros:
• Cons:

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

DirectQuery Mode: The Live Connector

In DirectQuery mode, Power BI does not store a copy of the data. Instead, it only stores the metadata (table names, column names, relationships). Every time you interact with a visual - like clicking a filter or opening a dashboard - Power BI sends a query directly to the original data source to fetch the data it needs.

• Pros:
• Cons:

Why and When to Switch to Import Mode

DirectQuery has its place for truly massive datasets or when real-time reporting is an absolute must-have. However, many teams default to it and end up with a frustrating user experience. You should seriously consider switching to Import mode if:

• Your reports are unbearably slow. This is the most common reason. If users have to wait more than a few seconds for visuals to update, they'll stop using the report. Switching to Import mode will almost always provide a dramatic speed boost.
• You need more advanced calculations. If you're trying to perform complex time intelligence analysis ("Year-over-Year Growth"), basket analysis, or other sophisticated DAX acrobatics, Import mode is your friend. It removes the DAX compatibility handcuffs imposed by DirectQuery.
• Your IT team is complaining about database load. A popular DirectQuery dashboard can feel like a denial-of-service attack on your source SQL server. Switching to Import significantly reduces that pressure.
• You need to merge data from multiple platforms. The true power of Power BI lies in combining different datasets. If you need to map your advertising spend from Facebook Ads against sales data from Shopify and throw in customer support tickets from Salesforce, Import mode makes this mashup possible.

How to Switch From DirectQuery to Import Mode: a Step-by-Step Guide

Making the switch is surprisingly straightforward, but you need to do it carefully. You can switch on a table-by-table basis or change the entire model at once.

Before You Start: A Quick Sanity Check

1. Back up your file! This is the most important step. Before you change anything, save a copy of your PBIX file with a name like my_report_v2_before_import_switch.pbix. This gives you a safe fallback if anything goes wrong.
2. Check your model size. Take a look at the source database. Is the data less than 1 GB? For a Power BI Pro user, this is a soft limit for the published file. If your dataset is huge (e.g., 50GB), a full import might not be feasible without a Premium capacity.
3. Consider a mixed approach. Sometimes, you only need to import smaller "dimension" tables (like a product lookup table or a calendar table) while leaving your massive "fact" table (like a sales transaction log) in DirectQuery. This is called a "Composite Model" and can offer a nice balance.

The Switching Process in Power BI Desktop

Once you’ve got your backup ready, follow these steps:

1. Open your PBIX file in Power BI Desktop. Let it load completely.
2. Navigate to Model View. Click on the icon representing the relationships diagram on the left-hand sidebar. It's the third icon down.
3. Select the Table You Want to Switch: In the Model View, you'll see diagrams for each table. Click on the table you wish to convert from the pane on the right. This will show all its properties.
4. Find the Properties pane. This pane is located on the right-hand side. Look for the "Storage Mode" in the properties list.
5. Change the "Storage Mode." Under the “Advanced” section of the properties, use the drop-down menu to switch from "DirectQuery" to "Import."
6. Select "Import" and Apply. Choose "Import" and confirm your selection. Remember that this action cannot be undone. Confirm your choice and let Power BI proceed with importing the data.

At this point, Power BI will begin pulling the data from the source into your file. Depending on the size of the table, this could take anywhere from a few seconds to several minutes. You'll see a loading window while it imports.

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

What if I Have Multiple Tables?

If you have multiple DirectQuery tables and want to convert them all at once, there's a setting for that. In the bottom-right corner of the Power BI Desktop window, you'll see text that likely says “Storage: DirectQuery.” Clicking this link will bring up a dialog that allows you to change the storage mode for all tables, switching them to Import.

What to Do After You’ve Switched

Switching your storage mode isn't the final step. Because your data is now a static copy, you need to tell Power BI how to keep it fresh.

Step 1: Publish Your Report

Once you've tested that everything works locally, save your file and publish it to the Power BI Service (your workspace in app.powerbi.com).

Step 2: Configure Gateway and Credentials

In the Power BI Service, find your dataset settings. You'll need to provide credentials so Power BI can securely access the original data source for refreshing. If your data source is on-premise, you will need an On-premises Gateway.

Step 3: Set Up a Scheduled Refresh

This is where you automate updates. In the same dataset settings area, you'll find the "Scheduled refresh" section. Here you can configure how often you want the import to happen. You can set it to refresh daily at a specific time (e.g., every morning at 6 AM) or multiple times per day (Pro users get up to 8 times, Premium users get 48).

This ensures your report is always updated with reasonably recent data, giving you great performance without sacrificing too much freshness.

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

Step 4: Test Everything Thoroughly

Finally, browse the published report. Test filters, click on visuals, and share it with a few colleagues. Confirm that the user experience is dramatically faster and that all the data looks correct after a scheduled refresh.

Final Thoughts

Choosing the right data connection mode in Power BI is a critical decision that impacts everything from report speed to your analytical capabilities. While DirectQuery is necessary for some specific real-time or massive data scenarios, many teams will get far more value and better performance by switching to the powerful and flexible Import mode.

We believe getting business insights shouldn't require you to become an expert in storage modes and data gateways. At Graphed, we automate this entire process by connecting directly to your marketing and sales platforms like Google Analytics, Shopify, and Salesforce. There's no complex setup or refresh scheduling to worry about. You simply ask your questions in plain language and get live-updating dashboards delivering you answers instantly.