How to Add a Connection in Power BI

You have the data. You have Power BI open. But nothing is connected yet — and that blank canvas is doing nothing for your business.

Here is the truth: Power BI is only as powerful as the data you feed it. And with over 250,000 organizations worldwide already using Power BI to drive decisions, the difference between those getting real value and those still stuck in spreadsheets usually comes down to one thing — knowing how to connect the right data sources, fast.

Whether you are pulling from an Excel file, a SQL database, a cloud service like Salesforce, or a live API, Power BI gives you a direct line to your data. This guide walks you through every step of adding a connection in Power BI, from the basics to the advanced, so you can stop guessing and start building.

What Is a Power BI Connection?

A Power BI connection is the bridge between Power BI Desktop (or the Power BI Service) and the data source you want to analyze. Without a connection, Power BI is just a visualization shell. With one, it becomes a live, interactive intelligence engine.

Power BI supports over 100 native data connectors — from simple Excel files to complex enterprise databases, REST APIs, and cloud platforms. According to Microsoft, the platform sees millions of active users monthly, with data connectivity being the single most-used feature in the product.

There are two primary ways data connections work in Power BI:

• Import mode — Data is loaded and stored inside Power BI. Refreshes happen on a schedule.
• DirectQuery mode — Power BI queries the source in real time. No data is stored locally.
• Live Connection — Used specifically with Analysis Services or Power BI datasets for near-real-time sync.

Choosing the right connection mode matters. Import mode is faster for dashboards but can become stale. DirectQuery keeps data current but can slow down visuals if the source is large.

Why Getting Connections Right Matters More Than You Think

Here is a stat that should stop you mid-scroll: Gartner reports that poor data quality costs organizations an average of $12.9 million per year. A significant portion of that waste comes from disconnected or improperly configured data pipelines — exactly the problem Power BI connections solve when set up correctly.

Additionally:

• IDC research shows organizations that invest in self-service BI tools like Power BI see up to a 15% increase in revenue from faster, data-driven decision-making.
• Microsoft’s own data shows that companies using Power BI report a 50% reduction in time spent on reporting compared to manual methods.
• Forrester Consulting found that Power BI users experience a 366% ROI over three years when fully leveraging connected data sources.
• Power BI holds approximately 36% of the business intelligence market share, making it the most widely adopted BI tool globally.
• 97% of Fortune 500 companies use Microsoft products — and a significant number of them integrate Power BI as their primary reporting layer.

The bottom line: getting your connections right is not a technical nicety. It is a business-critical move.

Before You Start: What You Need

Before adding any connection in Power BI, make sure you have:

• Power BI Desktop installed (free download from Microsoft) or access to Power BI Service (browser-based)
• Credentials for the data source you want to connect to (username, password, API key, or database connection string)
• Permissions to read from the data source
• A clear understanding of whether you want Import or DirectQuery mode

Power BI Desktop is where most connections are built and configured. Power BI Service is where published reports live and where data refresh schedules are managed.

How to Add a Connection in Power BI Desktop

This is the core workflow. Follow these steps exactly and you will have your first connection live in under five minutes.

Open the Get Data Menu

Launch Power BI Desktop. On the Home ribbon at the top, click Get Data. A dropdown will appear with the most common connectors. If you see your source listed, click it. If not, click More… at the bottom of the dropdown to access the full connector library.

Choose Your Data Source

The Get Data dialog opens with a searchable list of over 100 connectors organized by category:

• File — Excel, CSV, XML, JSON, PDF
• Database — SQL Server, MySQL, PostgreSQL, Oracle, Amazon Redshift
• Power Platform — Dataverse, Power BI datasets
• Azure — Azure SQL, Blob Storage, Data Lake
• Online Services — SharePoint, Salesforce, Google Analytics, Dynamics 365
• Other — Web, OData, ODBC, Blank Query

Select the connector that matches your data source and click Connect.

Enter Connection Details

Each connector will prompt you for different information:

• File connectors — Browse to your file location and click Open
• Database connectors — Enter the server name, database name, and select Import or DirectQuery
• Web connectors — Paste the URL
• Cloud services — Enter your account credentials or OAuth login

For database connections, you will typically see a field for the Server (e.g., myserver.database.windows.net) and the Database name. Fill these in accurately.

Authenticate

Power BI will ask how you want to authenticate. Options vary by connector but typically include:

• Windows authentication (for on-premises SQL Server)
• Database credentials (username and password)
• Microsoft account (for Azure, SharePoint, and cloud services)
• OAuth2 (for Salesforce, Google Analytics, etc.)
• API key (for some REST APIs)

Select the appropriate method, enter your credentials, and click Connect.

Preview and Transform Your Data

Once connected, Power BI shows you a Navigator window. This is a preview of your data — tables, sheets, or folders depending on your source. Check the boxes next to the tables or files you want to load.

You now have two choices:

• Load — Bring the data directly into Power BI as-is
• Transform Data — Open Power Query Editor to clean, reshape, or filter before loading

For most use cases, click Transform Data first. It gives you a chance to remove unnecessary columns, fix data types, and filter rows — all before anything hits your report canvas.

Load and Start Building

Once you are satisfied with your data shape in Power Query, click Close & Apply in the top-left corner. Power BI loads the data and makes it available in the Fields panel on the right. You are now connected and ready to build visuals.

How to Add a Connection in Power BI Service

Power BI Service (the browser version at app.powerbi.com) handles connections differently — primarily through Datasets and Dataflows.

Connect via a Published Dataset

If a report has already been published from Power BI Desktop:

Navigate to your Workspace → click + New → select Report → choose Pick a published dataset. Select the dataset you want and click Create. The connection is already embedded in that dataset.

Add a New Data Source via Dataflows

Dataflows allow you to build reusable data pipelines in the cloud.

Go to your Workspace → click + New → select Dataflow. Choose Add new tables and follow the same connector flow as Desktop. Dataflows are ideal for teams where multiple reports need to draw from the same prepared data.

Configure Gateway for On-Premises Sources

If your data lives on a local server (not in the cloud), you need a Data Gateway. The gateway is a bridge software installed on a local machine that allows Power BI Service to reach your on-premises data securely.

To configure:

Go to Settings (gear icon) → Manage gateways → Add data source. Select the connection type, enter the server and database details, and enter credentials. The gateway will validate the connection and make it available for scheduled refresh.

Key stat: According to Microsoft, organizations using the On-Premises Data Gateway see up to 4x faster data refresh cycles compared to manual export/import workflows.

How to Add a Connection to Specific Data Sources

Excel and CSV Files

This is the most common starting point for new Power BI users. In Get Data, select Excel Workbook or Text/CSV. Navigate to your file, click Open, then choose which sheets or named ranges to load. If your file has multiple sheets, the Navigator lets you select exactly what you need.

Pro tip: Store your Excel files on SharePoint or OneDrive instead of a local drive. This enables automatic refresh without a gateway.

SQL Server

Select SQL Server from Get Data. Enter the server address and database name. Choose between Import and DirectQuery. For most analytical workloads, Import is recommended unless you need real-time data. Use Windows Authentication if you are on a corporate network, or Database credentials if you are connecting remotely.

SharePoint and SharePoint Lists

In Get Data, search for SharePoint Online List or SharePoint Folder. Paste the root URL of your SharePoint site (not the list URL). Sign in with your Microsoft account. Power BI will show all available lists in that site — select the ones you need.

Salesforce

Search for Salesforce Objects or Salesforce Reports in Get Data. Sign in using your Salesforce credentials via OAuth. You can pull standard objects like Accounts, Contacts, and Opportunities — or connect to custom Salesforce reports you have already built.

Note: Salesforce connections in Power BI are Import mode only. DirectQuery is not supported for this connector.

Web / REST API

Select Web from Get Data. Paste your API endpoint URL. If the API requires authentication, click Advanced and add headers (such as Authorization: Bearer YOUR_TOKEN). Power BI will return the JSON or XML response and let you expand nested data in Power Query.

Google Analytics

Search for Google Analytics in Get Data. Connect using your Google account. Select the account, property, and view. You can pull data on sessions, users, bounce rates, conversions, and more directly into your Power BI reports.

Managing and Refreshing Your Connections

Once your connections are set up, you need to keep them current. Here is how.

Scheduled Refresh in Power BI Service

After publishing a report, go to your dataset in Power BI Service. Click the three dots (…) next to the dataset → Settings → Scheduled refresh. Toggle it on, choose frequency (daily, weekly, specific times), and save.

Power BI allows up to 8 refreshes per day on Pro licenses and 48 refreshes per day on Premium. For most teams, daily refresh is sufficient. For sales or ops dashboards, consider hourly.

Changing Data Source Credentials

If your password changes or credentials expire, go to your dataset Settings → Data source credentials → click Edit credentials next to the relevant source. Update and save.

Viewing All Connections in a Report

In Power BI Desktop, go to Home → Transform Data → Data Source Settings. This shows every data source the current report is connected to. You can update credentials, change the source path, or remove connections from here.

Common Connection Issues and How to Fix Them

Even experienced Power BI users run into connection problems. Here are the most common ones and how to resolve them fast.

“Unable to connect” error — Double-check the server name and database name for typos. Verify the server is accessible from your network. If connecting to an on-premises source from Power BI Service, confirm your gateway is online.

Authentication failure — Re-enter your credentials. If using Windows auth on a corporate machine and it fails remotely, switch to Database credentials. For cloud services, try signing out and back in via OAuth.

Gateway not found — Make sure the On-Premises Data Gateway software is running on the host machine. Check that the gateway is registered under your Power BI account in Settings.

Data not refreshing — Verify your scheduled refresh settings. Check that credentials have not expired. If using a gateway, check its status in the Gateway Management section of Power BI Service.

Timeout errors on large datasets — Switch from DirectQuery to Import mode if possible. Use Power Query to filter data to only what you need before loading. Consider using Incremental Refresh (available on Premium) to only load new or changed data.

Connector not available in Power BI Service — Some connectors only work in Power BI Desktop, not Service. In those cases, build and publish the report from Desktop with the data already loaded, then schedule refresh via a gateway.

Best Practices for Power BI Connections

Getting connected is step one. Getting connected well is what separates dashboards that get used from dashboards that get ignored.

Use a centralized data source wherever possible. Instead of 10 different reports each connecting directly to a database, build one master dataset or dataflow and have all reports pull from that. This reduces load on your source systems and makes updates easier.

Always use named tables in Excel. When connecting to Excel files, format your data as an Excel Table (Ctrl + T) and give it a meaningful name. This makes the Navigator much easier to work with and prevents issues when rows are added.

Set data types immediately. When loading data, check that Power BI has assigned the correct data types to each column — especially dates and numbers. Incorrect types cause calculation errors downstream.

Parameterize your connections. If you connect to environments (dev, staging, production), use Parameters in Power Query to switch between them without rebuilding the entire query. This is a workflow-saver when moving reports between environments.

Document your connections. Add a blank table or a report page that lists every data source, refresh schedule, and contact owner. When something breaks at 9 AM before a board meeting, you will thank yourself for having this.

Conclusion

Adding a connection in Power BI is not complicated — but it is consequential. Every insight, every dashboard, every decision your team makes from a Power BI report traces back to whether the right data was connected correctly.

The steps are straightforward: open Get Data, choose your connector, authenticate, preview your data, and load. But the real leverage comes from understanding which connection mode fits your use case, how to configure gateways for on-premises data, and how to keep your connections healthy with proper refresh schedules and credential management.

With 250,000+ organizations depending on Power BI and market share sitting at 36% of global BI adoption, the platform is not going anywhere. And neither is the advantage that comes from using it well.

Start with one data source. Get it connected and clean. Then layer in the next. That is how the best data teams operate — methodically, not all at once.

Your data is ready. Now go build something worth looking at.