📊 Import Data

Last Updated : 17th September 2025

Power BI allows you to import data from various sources, such as Excel, CSV, databases, and web sources. Here's how to import data into Power BI:

Home ➝ Get Data

  1. Choose the source (Excel, SQL Server, Web, etc.).
  2. Select the data you want to import.
  3. Connect to the data source.
  4. Configure the import options.
  5. Import the data into Power BI.

Import Excel Workbook

Home ➝ Get Data ➝ Excel Workbook ➝ Select File

Choose specific sheets or named ranges.

Import CSV File

Home ➝ Get Data ➝ Text/CSV ➝ Select File

Power BI auto-detects delimiter and formats.

Import from Web

Home ➝ Get Data ➝ Web ➝ Paste Page URL

You can import HTML tables, JSON, or APIs from the web

e.g. https://en.wikipedia.org/wiki/World_population

Load vs Transform Data

After selecting data, choose:

  • Load: Directly loads data to report
  • Transform Data: Opens Power Query Editor for cleaning

Always prefer Transform to clean before loading.

Refreshing Imported Data

Home ➝ Refresh Data

Refresh updates data in your report from the source file.

← PreviousNext →