10. Parameters in Power Query (and Other Kinds of Parameters)
10.1 What Is a Parameter and Why Use It?
A Power Query parameter is a named, typed value that queries use instead of hard-coded text. Examples in our project:
| Parameter | Type | Example value | Used in |
|---|---|---|---|
FolderPath |
Text | C:\QuickCommerce\Blinkit\ |
Folder connector (Module 7.20, 9) |
ServerName |
Text (list) | QCTEST01 / QCSERVER01 |
Sql.Database(ServerName, DatabaseName) |
DatabaseName |
Text | QuickCommerceDB |
SQL connection |
StartDate |
Date | 01-01-2025 | Filter orders from this date |
SelectedCity |
Text (list) | Pune, Solapur, Nashik, Sambhaji Nagar, Kolhapur, Nagpur | A city-specific extract |
RangeStart / RangeEnd |
Date/Time | set by the Service | Incremental refresh (10.8) |
Simple bhashet sangaycha tar, benefits: one place to change a value, easy Dev/Test/Prod switching, reusable templates, and it is required for incremental refresh.
Ravindra Bagale's Tip
Mitrano, khup students create parameters but never use them in the query, so changing the value does nothing. After creating a parameter, open the source step and replace the hard-coded text with the parameter name. Then change the value once to prove it works. Dhyan rakho!