Deployment pipeline parameter with Power Query

[Anonymous]

Hello,

I am trying to set the different data for my Test and Production environment in the same report. What I did was to create the Environment Parameter with values Staging and Production. As my data for different envs comes from the same database I applied the following steps to achieve this:

let
     environment = #"Environment",
     Source = Sql.Database("<server name>", "<database>"),
     schema = if environment = "Production" then "db_reporting_prod" else "db_reporting_stag",
     db_reporting_prod_user = Source{[Schema=schema,Item="app_user"]}[Data],
.....

For switching the environment in PowerBI desktop it works perfectly fine. But when I set Parameter rule Environment = Production in my Deployment Pipeline for Production environment, the data still appears to come from the default one which is Staging.

I feel like I did everything right and have no clue what is going on. I tried to refresh the dataset manually and it still shows staging data. Any ideas what is wrong here?

Thanks for your support 🙂

[Anonymous]

Ok, if anyone else has the same problem, you need to deploy it once again when you set the parameter rule.

[blopez11]

Yes, you have to deploy it first, set the parameter rule, then redeploy for the rule to be executed.