Power Query – basics

Power Query can be used to retrieve, modify and optimize data in Power BI, Excel and e.g. In Dataverse databases. With the help of Power Query, the data can be prepared in just the right way for future use.

Goal

Learn how to use Power Query for the most typical data editing needs.

Target Audience

The training is intended for everyone interested in editing and modeling information.

Content

Introduction to Power Query

• What is Power Query?
• User interface and navigation
• Supported data sources
• Managing survey steps
• Getting to know the Advanced Editor

Combining several source tables into one

• Combining several table columns into one table
• Combining several table rows into one table

Column management

• Removing unnecessary columns
• Determining the data type of a column and its effect on the usability of the values
• Time unit conversion within a column
• Table pivoting and unpivoting
• Splitting column values ​​into one or more columns
• Converting a column to a list
• Creating a new calculated column

Row management

• Specifying the first row values ​​as column headings
• Removing unnecessary rows by filtering
• Reversing the relative order of rows
• Removing duplicate values
• Grouping rows and combining row values ​​into one row

Value management

• Substitution of values
• Replacing errors with value
• Automatic filling of empty cells

Keywords

Power Query, Power BI, Excel, Dataverse, Power Platform