How to Add Data to Power BI Dashboard

Populating your Power BI dashboard is the first real step toward turning raw numbers into smart business decisions. This guide will show you exactly how to add your data, walking through the process of connecting to everything from a simple Excel file to online services like Salesforce, and then getting that data ready for your first visualization.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding How Power BI Connects to Data

Before you import your first file, it helps to know the two primary ways Power BI handles data connections: Import and DirectQuery. Choosing the right one depends on your data source, its size, and how fresh you need your information to be.

Import Method

This is the most common and often best-performing method. When you use the Import method, Power BI loads a full copy of your data into its internal memory.

• Pros: Because the data is stored inside your Power BI file, performance is incredibly fast. You also get access to the full suite of data transformation capabilities in the Power Query Editor.
• Cons: There's a limit to the dataset size per model (usually 1 GB for Power BI Pro). Also, the data is a snapshot, to see updates, you must schedule a refresh, which means your data isn't truly real-time.

For most users working with Excel sheets, CSVs, and smaller databases, the Import method is the default and the best way to go.

DirectQuery Method

DirectQuery works differently. Instead of importing a copy of the data, Power BI leaves the data at its source and sends queries to that source whenever you interact with a report. Think of it as a live, direct line to your database.

• Pros: This method is ideal for massive datasets that are too large to import. Since it queries the source directly, your reports always show the most up-to-date information, making it perfect for real-time analytics.
• Cons: Performance can be slower as it depends on the speed of the underlying data source. The options for data transformation in Power Query are also more limited compared to the Import method.

You'll primarily see the option for DirectQuery when connecting to database-type sources like SQL Server, Google BigQuery, or Snowflake.

Live Connection

A third, more specialized option is the Live Connection. This is used almost exclusively for connecting to SQL Server Analysis Services (SSAS), Azure Analysis Services, or a Power BI dataset. With a Live Connection, you're connecting to an already-built data model, meaning you can't access Power Query or the data modeling view - you can only build reports on top of it.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Add Data from Common File Types

Getting your data into Power BI Desktop starts at the "Home" ribbon. You’ll see a large "Get Data" button that, when clicked, reveals dozens of potential sources. Let's start with the most common file-based sources.

Connecting to an Excel Workbook

Excel spreadsheets are often where a company's data story begins. Connecting them to Power BI is a breeze.

1. From the Home tab, click Get Data and select Excel workbook.
2. Navigate to your Excel file on your computer and click Open.
3. The Navigator window will appear. Here, Power BI shows you all the available sheets and tables in your workbook.

Pro Tip: It's always best practice to connect to a named Table in Excel rather than a worksheet if possible. Tables are structured ranges that ensure you only pull in the specified data, whereas connecting to a full sheet might drag in extra blank rows, columns, or miscellaneous notes outside your main data area.

Once you’ve selected the table or sheet you want, you have two options:

• Load: This loads the data directly into your Power BI model as-is. This is fine for perfectly clean data.
• Transform Data: This opens the Power Query Editor. You should choose this 90% of the time, as most data needs a bit of tidying up before it's ready for analysis.

Connecting to a CSV or Text File

CSV (Comma-Separated Values) files are another popular format, often used for exporting data from web applications.

1. Click Get Data and select Text/CSV.
2. Locate and open your file.
3. Power BI will display a file settings dialog. It usually does a great job of guessing the file origin (character encoding) and delimiter (like a comma or tab), but you can adjust these here if the preview looks incorrect.
4. Just like with Excel, you'll have the choice to Load or Transform Data. Always lean towards transforming, as CSVs often require you to promote the first row to headers or adjust column data types (like changing a "Date" column from plain text to an actual date format).

Connecting to a Folder of Files

This is a particularly powerful yet often overlooked feature. If you have multiple files that all have the same structure - for example, a daily sales report CSV exported into a folder - you can connect to the entire folder at once.

1. Click Get Data, then select More... at the bottom of the list.
2. In the Get Data dialog, select Folder and click Connect.
3. Browse to the folder containing your files and click OK.
4. Power BI will show you a list of the files in that folder. Here, you should click Combine & Transform Data.
5. Power BI will walk you through a short process to use the first file as an example, automatically creating a query that will consolidate all the files in the folder into one single table. Every time you add a new file to that folder and refresh, it will be automatically added to your dataset.

Connecting to Online Services and Databases

Power BI truly shines when it connects directly to your business-critical systems, pulling data straight from the source. The process is similar to connecting to a file, just with different connection details required.

Connecting to a Web Source

You can pull data directly from public tables on a webpage.

1. Go to Get Data > Web.
2. Paste the URL of the webpage that contains the data table (for example, a Wikipedia page with a list of country populations).
3. Power BI will scan the page and the Navigator will display any HTML tables it found.
4. Select the table you want and click Transform Data to clean it up. Keep in mind that web data may need significant cleaning.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Connecting to a SQL Server Database

For many organizations, core business data lives in a SQL database.

1. Go to Get Data > SQL Server.
2. Enter the Server name and, optionally, the Database name if you know it.
3. Here you will see the critical choice: Import or DirectQuery. Refer back to the first section to help you decide. For reports that don't need to be updated more than once a day and aren't gigabytes in size, Import is fine. For live, operational dashboards connected to enormous tables, choose DirectQuery.
4. Click OK and enter your credentials if prompted. You can then navigate the database structure to find the tables or views you need.

Connecting to SaaS Platforms (e.g., Salesforce, Google Analytics)

Power BI includes native connectors for dozens of popular Software-as-a-Service (SaaS) platforms, allowing you to pull your marketing, sales, and operational data directly into your reports. For example, to connect to Salesforce:

1. Go to Get Data > More... and search for Salesforce.
2. Choose whether to connect to Salesforce Objects (the raw tables like 'Lead,' 'Opportunity,' 'Account') or Salesforce Reports (pulling data from a pre-built report in your Salesforce instance). Connecting to Reports is often easier if someone has already configured them for you.
3. You'll be prompted to sign in with your Salesforce credentials to authorize the connection.
4. Once connected, you can navigate your objects or reports just like any other data source.

The process is similar for other connectors like Google Analytics, Adobe Analytics, or SharePoint. You simply find the named connector, sign in, and you’re ready to go.

After Connecting: Preparing and Managing Your Data

Bringing data into Power BI is just the first step. To make it useful, you'll need to clean it up and define how your different data tables relate to one another.

Get Comfortable with the Power Query Editor

Every time you select "Transform Data," you enter the Power Query Editor. This is your data workshop. It’s where you shape, clean, and standardize your information before it ever hits your report visuals. Common tasks include:

• Removing unnecessary columns: The fewer columns you have, the better your report will perform.
• Changing data types: Making sure numbers are treated as numbers, dates as dates, and text as text.
• Splitting columns: Breaking a "Full Name" column into separate "First Name" and "Last Name" columns.
• Promoting Headers: Telling Power BI that the first row of your data is actually a header row.
• Replacing values: Cleaning up inconsistent data entry, like changing all instances of "USA" and "United States" to just "USA."

As you perform these actions, each one is recorded in the Applied Steps pane on the right. This means your transformations are repeatable and can be easily edited or removed later if needed.

Managing Data Relationships in the Model View

If you've loaded more than one table - for instance, a Sales table and a Customers table - you need to tell Power BI how they connect. This happens in the Model view, accessible via the icon on the far left that looks like three connected boxes.

Power BI is smart and will often detect relationships automatically if your columns have the same name (e.g., CustomerID in both tables). If not, you can create one manually by simply dragging the key field from one table and dropping it onto the corresponding field in the other table. Establishing these relationships is fundamental to building visualizations that filter and slice across different sources of data correctly.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Adding Your Data to a Dashboard Visual

With clean data and defined relationships, you're finally ready to build. In Power BI, you create visuals in a Report within Power BI Desktop, and then publish that report to the Power BI Service where you can "pin" your favorite visuals to a shareable Dashboard.

Let's create a quick bar chart:

1. Go back to the Report view (the bar chart icon on the far left).
2. In the Visualizations pane on the right, click the stacked bar chart icon. A blank visual will appear on your report canvas.
3. From the Data pane, find your 'Sales' table and drag a categorical field like Product Category to the Y-axis field well in the Visualizations pane.
4. Next, drag a numeric field like Sales Amount from that same table to the X-axis field well.

Instantly, you have a chart showing your total sales by product category. From here, you can publish your report to the Power BI Service via the Publish button on the Home tab, find your report there, and hover over your new chart to see a thumbtack icon. Clicking that icon will let you "pin" it to a dashboard.

Final Thoughts

You now have a solid foundation for adding nearly any data source to a Power BI dashboard. The core workflow is always the same: connect to a source, use the Power Query Editor to transform and clean your data, define relationships in the Model view, and then begin building visualizations on the report canvas.

Manually connecting, cleaning, and managing data from all your different marketing and sales platforms for a tool like Power BI can be a time-consuming weekly chore. We built Graphed to solve this by automating the entire process. Graphed connects to all your sources like Google Analytics, Shopify, Facebook Ads, and Salesforce in just one click. You can then instantly create real-time reports and dashboards simply by describing what you want in plain English, getting you actionable insights in seconds instead of hours of busywork.