Question

You manage a Power BI report that connects to a SQL Server database. During development you point to a test server, but before publishing to production you must repoint the report to a production server without editing every query manually. You want a maintainable approach that lets you switch the server name from a single place and can be updated by report consumers in the Power BI service dataset settings. What should you do in Power Query?

Accepted Answer

Create a text parameter for the server name and reference it in the source step of each query.

Answer

Duplicate each query and hard-code the production server name in the duplicates.

Answer

Use the 'Change Source' dialog on each query to type the production server before every publish.

Answer

Add a custom column that stores the server name and filter the table by it.