How to Upload Excel to Power BI

Moving your data from Excel spreadsheets into Power BI is the first step toward creating interactive, dynamic reports. This lets you leave static charts behind and automate your analytics. This tutorial will walk you through exactly how to connect Excel to Power BI, including best practices for preparing your data and the different methods for importing it.

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, Why Connect Excel to Power BI Anyway?

While Excel is fantastic for data entry and ad-hoc analysis, Power BI is built for visualization and ongoing reporting. Connecting the two gives you the best of both worlds.

• Interactive Dashboards: Transform a flat spreadsheet into a dynamic dashboard where users can click, filter, and drill down into the data to find their own insights.
• Automated Refreshes: Set up your reports to automatically update with the latest data from your Excel file, ending the tedious cycle of manually rebuilding your charts every week or month.
• Combining Data Sources: Easily merge your Excel data with other sources. You can pull in sales data from your spreadsheet and combine it with ad spend data from Google Ads or website traffic from Google Analytics, all in one dashboard.

Before You Begin: How to Prepare Your Excel File for Power BI

A little preparation goes a long way. Before you import anything, spending two minutes getting your Excel file ready will save you hours of headaches later. Poorly structured data is the number one cause of issues in Power BI.

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 1: Format Your Data as a Table

This is the most important step. Don't just import a range of cells. Formatting your data as an official Excel Table makes it structured and clean. Power BI loves structured data.

To do this:

• Click anywhere inside your dataset.
• Go to the Insert tab on the ribbon and click Table (or use the shortcut Ctrl + T).
• Ensure the "My table has headers" box is checked if your data has column titles.
• Give your new table a descriptive name. Go to the Table Design tab that appears, and in the top-left corner, change the "Table Name" from "Table1" to something clear like "SalesData_Q3."

Why is this so critical? When formatted as a table, Power BI knows exactly where your dataset begins and ends. If you add new rows or columns later, the table expands automatically, and Power BI will pick up the new data on the next refresh without you having to adjust anything.

Step 2: Clean Up Your Data

Power BI works best with raw, 'tidy' data arranged in columns and rows. It doesn't interpret data the same way humans do. Review your file for these common issues:

• Remove Empty Rows and Columns: Delete any completely blank rows or columns inside your dataset.
• Un-merge Cells: Power BI hates merged cells. Select any merged cells and click "Unmerge Cells." Fill in the new empty cells with the appropriate value.
• Consistent Data Types: Make sure each column contains only one type of data. A "Sales" column should only have numbers, not text like "N/A" or "Pending." A "Date" column should only contain valid dates.
• One Header Row: Your table should have a single, simple row at the top for headers. Avoid multiple header rows or titles above the table in the same sheet.

How to Import an Excel File into Power BI: The Main Methods

There are two primary ways to bring your clean Excel file into Power BI Desktop. The method you choose depends on where your file is stored and how you want to handle data refreshes.

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 1: Importing from a Local File

This is the most straightforward method and perfect for testing or one-off reports where the source file won't be updated constantly. You're importing a file stored directly on your computer or a local network drive.

1. Open Power BI Desktop and Click "Get data." You can find this option on the Home tab of the ribbon. A common data sources window will appear. Select "Excel workbook."
2. Locate and Select Your Excel File. A file browser window will open. Navigate to where you saved your Excel file and click "Open."
3. Use the Navigator Window to Select Your Table. Power BI will inspect the file and show you a list of all available sheets and defined Tables. You'll see icons next to each: a spreadsheet icon for a sheet and a blue-header icon for a Table. Always select the Table you named earlier (e.g., "SalesData_Q3"), not the raw sheet. This ensures you import only the structured data.
4. Choose Between "Load" and "Transform Data." After selecting your table, you'll see two options at the bottom of the Navigator window:

Once you've loaded or transformed your data, you'll see your table available in the "Data" pane on the right-hand side of Power BI. You're now ready to start creating charts and graphs!

Method 2: Connecting to Files in OneDrive for Business or SharePoint

If your Excel file is a living document that gets updated regularly by you or your team, storing it in OneDrive for Business or SharePoint is the best approach. It makes refreshing your Power BI report significantly easier.

1. Get the File Path, Not the Share Link. First, navigate to your file in OneDrive or SharePoint in your web browser. Don't use the standard "Share" button. Instead, select the file and from the details pane or the menu, find the "Copy path" option. You want the uniform resource identifier (URL) that points directly to the workbook, not the temporary sharing link.
2. Use "Get data from Web" in Power BI. In Power BI Desktop, go to the Home tab and click Get data > Web.
3. Paste the URL. In the dialog box that appears, paste the URL you copied. You need to slightly modify it - remove the ?web=1 part at the very end of the URL for the connection to work reliably. Click OK.
4. Authenticate and Connect. Power BI will likely ask you to sign in. Select "Organizational account" and sign in with your Microsoft 365 credentials. Once authenticated, the same Navigator window from Method 1 will appear, allowing you to select your Table and either Load or Transform the data.

The huge benefit of this method is that when the report is published to the Power BI Service online, you can schedule it to refresh automatically as often as once per hour, without needing any complex on-premise gateways.

Handling Data Refreshes and Common "Gotchas"

Getting the data in is only half the battle. Keeping it up-to-date is how BI tools provide long-term value.

• For Local Files: If your Excel workbook is saved locally, you will need to manually click the "Refresh" button in Power BI Desktop each time the Excel file is updated. To schedule automatic refreshes online, you'd need to install and configure an on-premises data gateway, which acts as a bridge between your local file and the Power BI cloud service. This can be complex to set up.
• For Cloud Files (OneDrive/SharePoint): This is the recommended workflow. Once your report is published to the Power BI Service, you can go into the dataset settings and schedule recurring refreshes. Power BI can connect directly to your OneDrive file in the cloud, so no gateway is needed.
• Watch for a Changed File Path: If you import a local file and then move or rename it, your Power BI connection will break. You'll have to go into the data source settings within the Power Query Editor and point it to the new location.

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

Successfully importing your Excel data is the foundational skill for using Power BI. By taking a few moments to properly format your data as a Table and choosing the right connection method - local for one-off analyses or cloud-based for collaborative, always-fresh reports - you can build reliable and impactful dashboards.

While tools like Power BI are incredibly capable for deep analysis, their learning curve often involves mastering steps like data cleaning, connection types, and a new interface just to see your first chart. If your goal is to simply get clear, real-time answers from your data without the technical setup, we built Graphed to streamline this entire process. You connect your data sources (like Google Sheets, Google Analytics, or Shopify) in a few clicks, then ask for what you need in plain English - like "create a dashboard comparing Facebook Ads spend vs. revenue by campaign" - and we build and update it automatically. It turns hours of report building into a 30-second conversation.