How to Change Live Connection to Import in Power BI

Ever hit a wall in a Power BI report when you needed to add just one more data source, only to find the options are greyed out? This common roadblock happens when you're using a Live Connection, which limits you to a single, pre-existing data model. This tutorial explains exactly how to break out of that limitation by switching your connection to Import mode, giving you the full flexibility Power BI has to offer.

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 changing your connection type, it's essential to understand the three primary ways Power BI can connect to your data. The way you connect fundamentally changes what you can and can't do in your report.

1. Import Mode

This is the most common and powerful mode. When you use Import mode, Power BI loads a compressed copy of your data directly into the .PBIX file. You're working with a snapshot of the data from the last refresh.

• Pros: Insanely fast performance for visuals, full access to Power Query Editor for data transformations, and unrestricted use of DAX for creating measures and calculated columns.
• Cons: Data is only as current as your last refresh schedule. Large datasets can result in large file sizes and may hit size limits (e.g., 1 GB per dataset for Pro licenses).

2. DirectQuery Mode

With DirectQuery, no data is actually loaded into your Power BI file. Instead, your file contains only the table structures and metadata. Every time you interact with a visual, Power BI sends a query directly to the underlying data source to fetch the latest data.

• Pros: Excellent for extremely large datasets that won't fit into memory and for reports that require real-time data.
• Cons: Slower visual performance, as it depends on the source's query speed. There are also significant limitations on the Power Query transformations you can use.

3. Live Connection Mode

Live Connection is a special, more restrictive type of DirectQuery. It’s used specifically to connect to an existing data model, such as a SQL Server Analysis Services (SSAS) model, an Azure Analysis Services (AAS) model, or another Power BI dataset already published in the Power BI service. This is amazing for creating a "single source of truth."

However, when using a Live Connection, you cannot edit the data model, create relationships, use Power Query, or add any other data sources. Your .PBIX file is purely a visualization layer sitting on top of a ready-made model elsewhere.

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

Why You Can’t Just “Switch” From Live Connection

The number one source of frustration is discovering there isn’t a simple button like "File > Change Connection Type" to switch from Live to Import. This is by design. A Live Connection hands off the entire data model infrastructure - the tables, relationships, and measures - to an external source. Switching to Import mode means you're telling Power BI, "I want to take ownership of that model and bring it inside this PBIX file now."

This is a major architectural change. Luckily, there's a powerful and modern way to accomplish this that gives you the best of both worlds.

The Best Solution: Creating a Composite Model

For years, this problem was a huge headache requiring manual file hacks or tedious rebuilds. Fortunately, Microsoft introduced a feature called DirectQuery for Power BI datasets and Analysis Services. This allows you to convert a Live Connection into a local model, creating what's known as a "composite model."

This approach connects to your original "golden" dataset via DirectQuery while also allowing you to import other data sources (like an Excel file or a database) and integrate them. It's the perfect solution for when you need to enrich an existing, governed dataset with your own data.

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

Here’s How To Do It, Step-by-Step:

Step 1: Enable the Preview Feature (If Necessary)

Microsoft has made this a default feature, but if your options look different, it's always good to check.

1. In your live-connected Power BI report, navigate to File > Options and settings > Options.
2. Go to the Report settings section under Current File.
3. Look for the option that says "Allow users to connect to this model using a direct connection" and ensure it's checked. Usually on by default, newer Power BI versions made that transition from generic preview feature to specific to the model itself. However, the important feature is that you CAN connect, with the newest Power BI Desktop updates, out of the box.

Step 2: Add a Local Data Source

Now for the key step. With your Live Connection file open, try to get data from another source.

1. Go to the Home ribbon and click Excel workbook (or any other data connector).
2. Select your local Excel file, CSV, or configure your database connection.

Upon attempting to add another data source, you might receive a security warning indicating the change to a composite model. Simply confirm this change to proceed.

Step 3: Work with Your New Composite Model

That's it! Your report is now in a composite mode. You will see your newly imported data in the Fields pane alongside the tables from your original live-connected dataset.

You can now:

• Add More Sources: Keep adding data from other sources using Import mode or DirectQuery.
• Create Relationships: Go to the Model view and drag-and-drop to create relationships between your newly imported tables and the original dataset's tables.
• Write New Measures: You can now create your own DAX measures using data from any of the tables in your new composite model.

Alternative: A Full Conversion to Import Mode

Sometimes, creating a composite model isn’t enough. You might need full control to modify the original dataset’s tables in Power Query, in which case you need to fully convert everything to Import mode. This process is more manual and involves recreating your report.

Step 1: Identify the Original Data Source

First, figure out what your Live Connection is pointing to. Is it a dataset in the Power BI service? An AAS model? You need to know this so you can connect to it directly.

Step 2: Start a New Power BI File

Open a completely blank Power BI Desktop file. In this new file, go to Get data and select the correct connector (e.g., Power BI datasets).

Step 3: Connect Using "Import"

This is the most critical step. When the connection dialog appears, you will be given a choice to Connect live or to connect another way. It may be hidden behind an extra option click or two though! Make sure whatever dataset/SQL server you connect to is being done via import.

Power BI will now pull a complete copy of that data model — tables, data, relationships, and measures — into your new .PBIX file.

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: Copy Report and Rebuild Measures/Relationships

Unfortunately, your report visuals are not brought over when you do a full import. Sometimes when bringing in data this way, we 'lose' pieces along the path of transit. For example, your once perfectly ordered columns might now have a new order!

The time-saving trick here is to open two instances of Power BI side-by-side: your original live-connected report and your new import-mode report.

1. In the original report, click on a report page.
2. Press Ctrl + A to select all the visuals on the page.
3. Press Ctrl + C to copy them.
4. Click over to your new report file, add a blank page, and press Ctrl + V to paste.

Power BI is impressively good at re-mapping the visuals to the fields in your newly imported model. You may need to fix a few broken visuals, but it saves hours of work on recreating the report design.

Which Method Should You Choose?

Use a Composite Model when...

• ...you trust the original "golden" dataset but need to enrich it with your own data (e.g., ad-hoc analysis with an Excel file).
• ...you don't need to perform Power Query transformations on the original source's tables.
• ...you want to keep the benefit of real-time data from the original source while combining it with imported data.

Use a Full Import Rebuild when...

• ...you need complete control to modify all aspects of the data model, including performing deep transformations on the original source tables in Power Query.
• ...you need to add calculated columns to the imported tables.
• ...the performance of the original DirectQuery source is too slow, and you need the lightning-fast performance of an in-memory Import model.

Final Thoughts

Switching from a Power BI Live Connection to Import mode isn't as simple as flipping a switch, but it’s far from impossible. The modern composite model approach provides a clean and powerful way to add new data sources to your report without losing your original model's structure. For situations requiring full control, manually recreating the connection in Import mode offers unlimited flexibility.

Tools like Power BI are incredibly powerful, but getting your various data sources connected and modeled correctly is often the biggest hurdle. At Graphed, we’ve simplified this entire process. We allow you to connect all your marketing and sales platforms in seconds. From there, you just ask questions in plain English — like "Compare my Facebook Ads spending vs. Shopify revenue" — and we instantly generate the dashboards you need. It helps you skip the technical setup and get straight to the insights.