Parameter-Driven Source Path (Dev vs Prod) in Power Query M

Builds a data source path from a parameter so the same query can point at dev or prod without editing the M code.

Database & RefreshIntermediateparametersenvironmentdev prod

Power Query M code

let
    ServerName = if Environment = "Prod" then "prod-sql-server" else "dev-sql-server",
    Source = Sql.Database(ServerName, "YourDatabase")
in
    Source

Notes

Environment should be a Power Query text parameter with a list of values like Dev and Prod, switched before publishing.

Requirements

An Environment parameter, and matching dev/prod data sources.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Parameter-Driven Source Path (Dev vs Prod).