Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Deployment pipeline parameter with Power Query

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 🙂

2 REPLIES 2
Anonymous
Not applicable

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

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.