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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
JRoj
Frequent Visitor

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
JRoj
Frequent Visitor

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

blopez11
Resident Rockstar
Resident Rockstar

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors