extract_parameter
Replace hard-coded paths, servers, or URLs in Power Query with a reusable parameter and update all references, including prefix matches, to keep queries maintainable.
Instructions
Turn a hard-coded text value (path, server, URL) into a Power Query parameter and reference it everywhere. With match_prefix, "C:\Data" also rewrites "C:\Data\sales.csv" to SourceFolder & "\sales.csv".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| value | Yes | ||
| source | Yes | ||
| dry_run | No | ||
| queries | No | ||
| match_prefix | No | ||
| parameter_name | Yes |