Ravindra BagaleCourses & study guides

6. Power Query Essentials

6.8 Parameters (Overview)

A parameter is a named value, such as a folder path, a server name or a start date, that queries can use instead of hard-coded text. Create it with Home › Manage Parameters › New Parameter. Module 10 covers parameters fully: types, suggested values and lists, parameterised file and server paths, date-range filters, templates (.pbit), and the RangeStart/RangeEnd parameters used by incremental refresh (फक्त नवीन/बदललेला डेटा अद्ययावत करणे).

Ravindra Bagale's Tip

Mitrano, khup students hard-code a folder path like C:\Users\Ravindra\Desktop\Data and the report breaks on every other laptop and in the Service. Put paths, server names and date limits in parameters from the start (Module 10), so changing environments is a one-field edit. Ghabru naka, don-teen vela kela ki savay hote.