Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello.
I have a Production and Dev envionrment.
I want to set parameters on my report so my URL can be changed via the parameters in the deployment pipelines.
My Prod url is https://myurl.com
My Dev url is https://dev-myurl.com
I have a parameter set up, works fine for Dev, as i can just put in Dev. HOwever, Prod is blank. My Parameter wont save a blank value.
Ideally, i would like to be able to type in 'Production' in the parameter value and it points to null.
My source data is a ODATA, so my url looks like this. How can i wrap a parmeter up with an IF Statamenet to say, if Production, then null, else show parameter value
let
Source = Csv.Document(Web.Content("https://myurl.com")
In
Source
I thought u needed to create parameters to switch sources?.
Anyway, is what I want able in my post achievable?
So if I select Production as the parameter value, it sets the value to null, else we can set it to Dev?
You don't need to use parameters for that - the deployment pipeline already offers the option to switch sources.