In Power Query, a developer wants to parameterize a data source connection so the server name can be changed without editing query steps. What is the correct approach?

Question

Power BI — Hard

In Power Query, a developer wants to parameterize a data source connection so the server name can be changed without editing query steps. What is the correct approach?

Accepted Answer

Parameterizing a data source connection in Power Query allows for dynamic server name changes. The correct approach involves creating a Power Query parameter, which can be referenced in the data source connection step, enabling flexibility. This method is preferable as it keeps the server name separate from query steps.