Ravindra BagaleCourses & study guides

6. Power Query Essentials

By Last updated:

Chala mitrano, aaj aapan Power Query shikuya – Power BI cha sagalyat powerful bhag. Data saaf karna, aakar dena, aani te steps pratyek refresh la automatic chalvna, he sagla ithe hota. Ya module madhe editor, Applied Steps, data types, M language aani query folding (काम स्रोत डेटाबेसकडे सोपवणे) che basics pakke karu.

What you will learn in this module

  • The Power Query Editor layout, ribbon tabs and panes
  • Managing Applied Steps and understanding query dependencies
  • Data types (basics) – detailed type fixing is in Module 7
  • Reference vs Duplicate, parameters and an introduction to M
  • Query folding, Close & Apply and Enable load

Module 7 (Data Cleaning A–Z) and Module 8 (Add Column) build on this module. Read this one first.

Concepts in this chapter

  1. 6.1What is Power Query?
  2. 6.2Power Query Editor Tour
  3. 6.3The Power Query Ribbon at a Glance
  4. 6.4Applied Steps
  5. 6.5Data Types
  6. 6.6Reference vs Duplicate
  7. 6.7Query Dependencies
  8. 6.8Parameters (Overview)
  9. 6.9Introduction to the M Language
  10. 6.10Query Folding
  11. 6.11Close & Apply and Enable Load

The chapter recap is at the end of the last concept page.