How to Import CSV into Power BI

Importing data from a CSV file is often the first step in any Power BI project. This common file type is a simple way to get data out of one application and into another for analysis. This guide provides a straightforward, step-by-step walkthrough for loading your CSV files into Power BI Desktop, along with tips for avoiding common errors.

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 is a CSV File, Anyway?

Before jumping into Power BI, let's quickly clarify what a CSV file is. The acronym stands for Comma-Separated Values. It’s a plain text file that stores data in a table-like format.

Imagine a simple spreadsheet with rows and columns. In a CSV file:

• Each row of the spreadsheet becomes a new line in the text file.
• The values within each row (the individual cells) are separated by a comma or another designated character, called a delimiter.

For example, a list of sales might look like this in a spreadsheet:

As a CSV file, that same data would be a text file containing:

Date,Product,Revenue
2024-05-01,Widget A,500
2024-05-01,Widget B,750

Because they are simple text, CSV files are a universal standard for exporting data from countless platforms, including CRMs like Salesforce, ad platforms like Facebook Ads, email marketing tools, and e-commerce systems like Shopify. This makes knowing how to work with them an essential skill for any data analyst or marketer.

Preparing Your CSV File for a Smooth Import

A little bit of prep work on your CSV file can save you a lot of headaches inside Power BI. While Power BI's Power Query Editor is excellent for cleaning data, starting with a well-formatted file makes the process much more efficient. Here are a few things to check before you import.

1. Verify Your Header Row

Your CSV should have a single header row at the very top. This row provides the column names (e.g., 'Date', 'Product', 'Revenue'). Without a clear header, Power BI will likely misinterpret your first row of data as headers, causing confusion and requiring extra cleanup steps later.

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

2. Check for Data Consistency

Scan your columns to ensure the data is consistent. If you have a 'Revenue' column, it should only contain numbers. An errant text value like "N/A" or a note like "Refunded" in that column can cause Power BI to "break" on import or interpret the entire column as text instead of a number, preventing you from performing calculations.

3. Remove Unnecessary Clutter

Many data exports include extra fluff that isn’t useful for analysis. Before importing, it’s a good idea to delete:

• Completely blank rows or columns.
• Summary rows at the bottom of the file (e.g., a "Total" row). Power BI is built to calculate totals for you, so these pre-calculated rows can cause aggregation errors.
• Introductory text or notes that sometimes appear above the header row.

4. Save with UTF-8 Encoding

This sounds technical, but it's simple. "Encoding" is how a computer program interprets the characters in your text file. UTF-8 is the universal standard that handles a wide range of characters and symbols properly. Saving your file with UTF-8 encoding (most spreadsheet programs like Excel or Google Sheets do this by default when saving as a CSV) helps prevent weird symbols or formatting errors during import.

Step-by-Step Guide: Importing Your CSV into Power BI Desktop

With a clean CSV file ready to go, the import process in Power BI is straightforward. Follow these steps to get your data loaded.

Step 1: Open Power BI and Select "Get Data"

Launch Power BI Desktop. On the main Home ribbon at the top of the window, you'll find the "Get data" button. This is your starting point for connecting to nearly any data source. Click on it to open a menu of common data sources.

Step 2: Choose 'Text/CSV' as Your Data Source

From the "Get data" dropdown, select the 'Text/CSV' option. It’s one of the first and most common choices. If you don't see it immediately, click the main "Get data" icon to open a comprehensive dialog box, where you can find 'Text/CSV' under the 'File' category.

Step 3: Navigate to and Select Your File

A standard Windows File Explorer window will pop up. Navigate to the folder where you saved your CSV file, select it, and click "Open".

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

Step 4: Configure Options in the Preview Window

After you select your file, Power BI will scan it and show you a preview of the data in a new window. This screen is crucial for ensuring the data is interpreted correctly. Here are the options you'll see:

• File Origin: This relates to the character encoding we mentioned earlier. Power BI usually auto-detects this correctly. If you see strange characters or symbols in the preview, try changing this setting. '65001: Unicode (UTF-8)' is almost always the right choice.
• Delimiter: This is the character used to separate values. Power BI is smart and will typically identify whether your file uses a comma, semicolon, tab, or another character. If the preview shows all your data squished into one column, it means the wrong delimiter was detected. You can fix this by selecting the correct one from the dropdown.
• Data Type Detection: This setting tells Power BI how aggressively to scan your data to guess the data type for each column (e.g., number, text, date). The default "Based on first 200 rows" is usually fine, but if you have messy data, you can choose "Do not detect data types" and set them manually in the next step.

Review the preview. Does it look like a clean, well-organized table? If so, you're ready to move on.

Step 5: Choose Between Load or Transform Data

At the bottom right of the preview window, you have two primary options: Load and Transform Data. This is a critical fork in the road.

• Load: Clicking 'Load' will immediately pull the data directly into your Power BI data model as it appears in the preview. This is a good option only if you are 100% certain your data is perfectly clean and requires no changes. This is rarely the case with real-world data.
• Transform Data: This is the recommended option for almost every scenario. Clicking 'Transform Data' opens the Power Query Editor, a powerful tool within Power BI for cleaning, shaping, and preparing your data before it gets loaded into your model. This is where you can fix problems, rename columns, filter out unwanted rows, and more.

For best practice, always choose Transform Data.

Using the Power Query Editor to Polish Your Data

After clicking 'Transform Data,' you're now inside the Power Query Editor. This is where data transforms from a simple table into a reliable foundation for your reports and dashboards. You can perform hundreds of different transformations here, but for a basic CSV import, you'll commonly use a few key features:

• Changing Data Types: Check the icon next to each column header. A 123 icon means Whole Number, ABC means Text, and a calendar icon means Date. If Power BI got one wrong (e.g., a 'Year' column is marked as text), click the icon to change it to the correct type.
• Renaming Columns: Did your original file have an ugly column name like prod_revenue_usd? Simply double-click on the column header and type a friendlier name, like "Product Revenue."
• Filtering Rows: Just like in Excel, you can use the dropdown arrow on a column header to filter out unwanted rows. For example, you might want to remove rows where the 'Status' is "Test" or "Cancelled."
• Removing Unneeded Columns: If your CSV has 30 columns but you only need five for your report, you can clean things up by selecting the columns you don't need, right-clicking, and choosing "Remove Columns."

As you make these changes, Power Query records each action in the "Applied Steps" panel on the right. This is incredible because the next time you refresh your data, Power BI will automatically repeat all those cleaning steps for you. Once you’re happy with how the data looks, click the "Close & Apply" button in the top-left corner to load your clean data into Power BI and start building visuals.

Troubleshooting Common CSV Import Errors

Sometimes things don't go as planned. Here are fixes for three of the most common issues you might encounter when importing a CSV file.

Problem: Data is jumbled into a single column.

Cause: Power BI has selected the wrong delimiter.

Solution: In the Power Query Editor, find the "Applied Steps" panel. Click the gear icon next to the very first step, named 'Source'. This will reopen the initial preview window, where you can manually select the correct delimiter (e.g., Semicolon instead of Comma) from the dropdown list. The preview should immediately update to show properly separated columns.

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

Problem: Numbers are being treated as text (or vice versa).

Cause: A single non-numeric value in a number column, or data that needs a different type.

Solution: In the Power Query Editor, identify the column causing the issue. First, check that the data type is set correctly by clicking the icon in the column header. If Power BI isn't letting you change it to a number, it means there are values in that column it can't convert. Use the filter dropdown for that column to find the problematic text values (they will be listed alongside the numbers) and decide how to handle them — either by filtering them out or by using the 'Replace Values' feature to correct them (e.g., replace "N/A" with "0").

Problem: You see strange characters (, â€, etc.) in your data.

Cause: Incorrect character encoding ('File Origin').

Solution: Just like with the delimiter issue, you can fix this in Power Query. Go to the 'Applied Steps' panel, click the gear icon on the 'Source' step, and change the 'File Origin' setting to '65001: Unicode (UTF-8)'. This is the most common and compatible format and usually resolves these character issues.

Final Thoughts

Being able to import and clean a CSV file is a foundational skill for building meaningful reports in Power BI. By preparing your file, carefully navigating the import process, and taking advantage of the Power Query Editor, you can turn any simple text file into a powerful dataset ready for visualization and analysis.

This process of exporting CSVs from different platforms, cleaning them, and loading them into BI tools is a routine task for many marketing and sales teams. While powerful, it can become repetitive. At Graphed, we automate this entire workflow. Instead of manually exporting CSVs and importing them, we let you connect directly to your marketing and sales tools like Google Analytics, Shopify, Facebook Ads, and Salesforce. From there, you just ask questions in plain English to build real-time dashboards instantly, freeing you from a cycle of manual reporting.