Getting Data

Power Query can import data from sources such as:

  • Excel Workbook
  • Text/CSV
  • Web
  • Folder
  • Database
  • Other supported sources

Example

To import a CSV:

Data → Get Data → From File → From Text/CSV

Then select:

Transform Data

Power Query Editor

Important areas:

  • Queries Pane — lists queries
  • Data Preview — displays imported data
  • Query Settings — properties and Applied Steps
  • Formula Bar — displays Power Query/M expressions
  • Home / Transform / Add Column / View tabs

Key Concept

Every transformation is recorded under Applied Steps, making the process repeatable.

PreviousNext