Forum Discussion
URL Construct Using Parameters in Power BI
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
2 Replies
You don't need to use parameters for that - the deployment pipeline already offers the option to switch sources.
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?
