How to Input Data into Power BI

Power BI is an amazing tool for turning raw numbers into clear, interactive visuals, but it's only as good as the data you feed it. Getting your data into the platform correctly is the first and most critical step. This guide breaks down exactly how to input data into Power BI from the most common sources, from simple spreadsheets to live online services.

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

Understanding Your Data Connection Options

Before jumping into the step-by-step instructions, it’s helpful to know that Power BI can connect to a staggering variety of data sources. This flexibility is one of its greatest strengths. You aren’t locked into one specific type of file or database. Generally, your options fall into a few main categories:

• Files: These are the most common starting point for many users. This includes Excel workbooks (.xlsx, .xlsm), comma-separated value files (.csv), XML files (.xml), and even entire folders of files.
• Databases: For more robust and centralized data, Power BI can connect directly to dozens of database types, like SQL Server, PostgreSQL, MySQL, Oracle, and many more.
• Microsoft Power Platform: Power BI is tightly integrated with other Microsoft tools, allowing you to easily pull in data from Power BI datasets, dataflows, and Microsoft Dataverse.
• Azure: If your company uses Microsoft's cloud platform, you can connect directly to Azure SQL Databases, Azure Synapse Analytics, Azure Blob Storage, and other cloud-based data warehouses.
• Online Services: This category is a game-changer for business users. Power BI has built-in connectors for dozens of popular SaaS platforms, including SharePoint, Salesforce, Google Analytics, Mailchimp, and Dynamics 365.
• Other: And if your source isn’t listed, you can often still connect using generic methods like a Web feed, OData Feed, or an ODBC/OLE DB connection.

For now, let's focus on the methods you're most likely to use day-to-day: files, databases, and online services.

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

Method 1: Importing Data from Files

Connecting to a file stored on your computer or a shared drive is often the quickest way to get started with Power BI. Let's walk through importing the two most common file types: Excel and CSV.

How to Input Data from an Excel Workbook

Excel is the go-to data tool for millions, making it a natural starting point for Power BI. The key to a smooth import is ensuring your Excel data is formatted as a table.

Step-by-step instructions:

1. Open Power BI Desktop.
2. In the Home tab of the ribbon at the top, click on the Get Data icon.
3. From the dropdown menu, select Excel Workbook. (It's so common that it's usually one of the top options).
4. A file browser window will pop up. Navigate to where your Excel file is saved, select it, and click Open.
5. Power BI will then show a Navigator window. This window displays all the available tables and worksheets within your Excel file. A gold standard is to have your data formatted as an official Excel Table, which will appear with a distinct blue header icon.
6. Check the box next to the table or sheet you want to import. A preview of the data will appear on the right side of the window.
7. At the bottom of the Navigator window, you have two main options:

For best results, always spend a minute in the Power Query Editor to check for errors, correct data types (e.g., make sure dates are formatted as dates, not text), and remove any unnecessary columns.

How to Input Data from a CSV or Text File

CSV (Comma-Separated Values) files are another staple. They are simple text files used to store tabular data and are a common export format from many applications.

Step-by-step instructions:

1. In the Home tab of the ribbon, click Get Data.
2. Select Text/CSV from the dropdown list.
3. Navigate to your CSV file, select it, and click Open.
4. Power BI will analyze the file and show a preview window. Here, you have a few important settings:
5. Just like with Excel, you will then see the options to Load or Transform Data. Again, choosing Transform Data to open the Power Query Editor is highly recommended.

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

Method 2: Connecting Directly to a Database

If your organization stores its data in a centralized database like SQL Server, connecting Power BI directly is far more efficient than exporting files. This gives you a live link to the source of truth.

Step-by-step instructions (using SQL Server as an example):

1. In the Home ribbon, click Get Data.
2. Select SQL Server from the menu.
3. A connection settings window will appear. You'll need to fill in two key fields:
4. Below this, you'll see a crucial choice: Data Connectivity mode.
5. Click OK. You may be asked to enter your credentials (username/password) to authenticate with the database.
6. Once connected, the Navigator window will appear, just like it did with files. You can now browse all the tables and views in the database.
7. Select the tables you need, and then choose Load or Transform Data.

Method 3: Connecting to Online Services

One of the most powerful features of Power BI is its library of connectors for services you use every day, like Salesforce, HubSpot, or Google Analytics. This eliminates the need to manually export CSVs from these platforms every week.

Let's use a common business scenario: connecting to a list on a SharePoint site.

Step-by-step instructions (using SharePoint as an example):

1. In the Home ribbon, click Get Data.
2. If you don't see your desired service, click More... at the bottom of the dropdown to open the full data source library.
3. In the search bar, type "SharePoint" and select SharePoint Online List from the results. Click Connect.
4. You'll be prompted to enter the Site URL. This should be the root URL of your SharePoint site (e.g., https://yourcompany.sharepoint.com/sites/YourSite). You can usually just copy and paste this from your browser's address bar when you are on the site's home page.
5. Click OK. Power BI will then ask you to sign in. Select the appropriate account and complete the Microsoft 365 login process.
6. After signing in successfully, the Navigator window will show a list of all the content available on that SharePoint site.
7. Find and select the specific SharePoint List you want to analyze.
8. Finally, select Transform Data to open the Power Query Editor, where you can refine the columns before loading. Many online source connectors pull in a lot of metadata columns that you probably don't need, so cleaning up here is essential.

The process is very similar for other online services. You typically select the connector, provide a URL or sign in with your credentials, and then navigate to the specific report or data table you need.

Best Practices for Inputting Data

No matter which method you use, keep these tips in mind for a smoother reporting experience:

• Start with Clean Data: Garbage in, garbage out. The cleaner your source data is, the less work you'll have to do in Power Query. If possible, fix inconsistencies or errors in your source Excel file or database before you even connect Power BI to it.
• Use "Transform Data": Make it a habit to always click "Transform Data" instead of "Load." Taking a quick look at your data in the Power Query Editor can save you from major headaches down the line when visuals don’t work as expected.
• Remove Unneeded Columns: The fewer columns you load into your data model, the smaller your file size will be and the faster your reports will perform. Be ruthless - if you don't need a column for a filter, visual, or calculation, remove it during the "Transform Data" step.
• Check Your Data Types: One of the most common issues is a number column being misinterpreted as text or a date column being read incorrectly. In Power Query, quickly scan the icon at the top of each column to ensure it has the correct data type (e.g., 123 for whole number, ABC for text, calendar icon for date).

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

Final Thoughts

Learning how to input data is your gateway to unleashing the full potential of Power BI. As you've seen, the platform offers a flexible and powerful set of tools to connect to almost any data source you can think of, from a simple spreadsheet to a live connection with a CRM like Salesforce. Mastering these first steps is essential for building accurate and insightful reports.

For marketing and sales teams, however, the process of manually connecting different platforms like Google Analytics, Facebook Ads, Shopify, and a CRM can still feel fragmented and time-consuming, even with Power BI's connectors. That’s precisely the friction we set out to eliminate with Graphed. We provide one-click integrations for your key platforms and let you use simple natural language - not complex setup wizards or query editors - to build live, real-time dashboards in seconds, turning hours of reporting work into quick conversations.