Ravindra BagaleCourses & study guides

10. Parameters in Power Query (and Other Kinds of Parameters)

By Last updated:

Aata ek chhota pan khup upyogi topic – Parameters (बदलता येणारे मूल्य, जे अनेक ठिकाणी वापरता येते). File path, server name, date range he sagla hard-code kela tar dusrya laptop var report tutto. Ya module madhe parameters banvne, M madhe vaparne, templates aani incremental refresh che basics ekdum simple bhashet baghu.

What you will learn in this module

  • Creating and managing Power Query parameters: types, suggested values, lists, queries
  • Parameterising a file/folder path and a server/database name (Dev → Prod)
  • Date-range parameters for filtering (with query folding)
  • Using parameters inside M code and changing them in Desktop and the Service
  • Templates (.pbit) that ask for parameter values
  • Incremental refresh with RangeStart/RangeEnd (overview)
  • How what-if and field parameters differ (they are covered in Module 21)

Concepts in this chapter

  1. 10.1What Is a Parameter and Why Use It?
  2. 10.2Creating a Parameter (Manage Parameters Dialog)
  3. 10.3Parameterising a File or Folder Path
  4. 10.4Parameterising Server and Database (Dev → Prod)
  5. 10.5Date-range Parameters for Filtering
  6. 10.6Using Parameters Elsewhere in M
  7. 10.7Templates (.pbit) with Parameters
  8. 10.8Incremental Refresh with RangeStart and RangeEnd (Overview)
  9. 10.9What-if Parameters and Field Parameters Are Different

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