Ravindra BagaleCourses & study guides

6. Power Query Essentials

6.8 Parameters (Overview)

In short: 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.

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

Friends, many 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. Don't worry – after doing it two or three times, it becomes a habit.