Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power Query Editor in Power BI: Complete Introduction
Role Play
Rating: 4.6 out of 5(4,244 ratings)
15,556 students

Power Query Editor in Power BI: Complete Introduction

Connect, transform and cleanse data in the Power BI Query Editor, then republish refreshed reports in one click
Role Play
Created byIan Littlejohn
Last updated 8/2026
English
English [Auto],Spanish [Auto],

What you'll learn

  • Build a repeatable query in Power BI that reloads next month's file in one click, instead of redoing the import
  • Filter rows, change data types, remove and reorder columns, and add calculated columns in the Query Editor
  • Write conditional IF rules in the Query Editor to categorize your data without touching DAX
  • Merge two tables on a matching column, and append separate files into one table ready for modelling
  • Group and summarize data with Group By, and build custom calculations inside the query Find and fix broken data with Query Editor Diagnostics
  • Load data from SQL Server, CSV and text files, web pages, XML, JSON and published Power BI datasets

Course content

8 sections • 37 lectures • 2h 45m total length

  • Introduction to the Course2:24

    Introduction to the course and what we will be covering in the course

  • About the Course1:23
  • Please download the Training Data Files0:04
  • Welcome to the Udemy Roleplay0:36
  • Discussion about using Power BI Query Editor for your data analysis

Requirements

  • You will require Power BI desktop and access to the Power BI Service on the Internet
  • You should be able to work with data in Excel and do basic reporting
  • Download the Power BI Desktop app which is available free from Microsoft for Windows

Description

This course contains the use of artificial intelligence.

Every lesson in this course is written, created and recorded by me. AI is used only to help produce supporting images and written materials around the lessons.

Most Power BI reports fail before a single chart is drawn. The data arrives in three files with different column names, the dates are stored as text, and half the rows are duplicates. This course is about that half of the job.

You will work entirely in the Power BI Query Editor: connect to a source, shape it, clean it, and save the steps, so that next month's file loads the same way in one click.

WHAT YOU WILL BUILD

  • Basic transformations - filter rows, change data types, remove and reorder columns, and add calculated columns

  • Advanced transformations - merge two tables on a matching column, append separate files into one table, group and summarize, and write custom calculations

  • Conditional rules - categorize your data with IF logic in the Query Editor, without touching DAX

  • Data cleansing - find and fix broken data with Query Editor Diagnostics, before it reaches your model

  • Connect to data sources - SQL Server, CSV and text files, web pages, XML, JSON and published Power BI datasets

  • Power BI Service dataflows - move your queries into the Service so a whole team reuses the same cleaned data

Every section sets a practical activity and then walks through the answer on video, and eleven training data files mean you are working on exactly the data I am.

MEET YOUR INSTRUCTOR

I have been training business people to work with data since 2008, and publishing on Udemy since 2013. I now have 16 live courses, more than 450,000 enrolments and more than 139,000 reviews, averaging 4.6. This course is rated 4.6 from 4,235 ratings.

I specialise in teaching business users the analysis methods behind the tools - Microsoft Excel, Copilot in Excel, Microsoft Power BI, Looker Studio and Amazon QuickSight. I teach the analysis, not just the software.

WHAT STUDENTS ARE SAYING

  • "Step by step process allowed me to understand stuff immensely"

  • "I have learned a lot about power BI on this learning and I now have a better understanding about it"

  • "I had basic PBI knowledge, this course helped me to improve my current skills. Professional, understandable and clear communication with a lot of great examples which can be used for my work on daily basis. Thank you !!!"


Ready to stop rebuilding the same import every month? Start with the first transformation and see how much of your reporting time you get back.

Who this course is for:

  • Power BI users who spend more time fixing data than building reports, and want to automate the fixing once and reuse it.
  • Analysts who have built a Power BI report or two and now need to load from real sources - a database, a web page, a folder of files - rather than one tidy spreadsheet.
  • This is the data preparation course in my Power BI series. Complete Introduction to Microsoft Power BI is the place to start; it covers loading, modelling and your first reports, with a short introduction to the Query Editor. This course is the deep version of that introduction. Power BI Master Class - Data Models and DAX Formulas goes deeper on the model, and Power BI Master Class - Dashboards and Power BI Service goes deeper on the visuals and publishing.
  • If you want these same data preparation skills inside Excel rather than Power BI, take Complete Introduction to Excel Power Query instead. It covers the same ground in Excel's Power Query.
  • This course does not cover building reports, charts or dashboards. It is entirely about preparing the data those reports run on.

Report abuse