Assign Alias to Parameters

[kewaynes]

Hi,

I'm creating parameters so that we can switch our data connection easily between our databricks dev and prod workspaces. I've been able to do this. The only issue I have with it is that the parameters are ugly and indistinguishable to someone whose new to the report/environments. 

For example, the server hostname for each databricks workspace is something like this abd-XXXXXXXXX.net

I created parameters for this so that the developer can switch between the two servers, but a lot of developers won't know which one is dev and which one is prod, unless they go out to databricks and check.

So what I'm wondering is, is there a way to assign an alias to a parameter? So that when the developer selects the 'Dev' as the current value, it returns abd-12345.net. And then if the developer selected 'Prod' as the current value, it returns abd-76890.net

Any thoughts?

[amitchandak]

@kewaynes , You can create M parameter and use that in connection

refer: https://www.youtube.com/watch?v=OnaDJkGOmIE

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters

[kewaynes]

Thanks. I've done this. What I'm hoping to do is make it so the developer doesn't need to know which string is dev and which is prod. 

Right now, for example, they would have the option to choose flip the parameter between abd-12345.net and abd-67890.net. This allows them to switch easily between dev and prod. The issue is that not all developers will know which one of these is dev and prod. I was hoping to assign alias. So the developer could just change the parameter to the 'Dev' or 'Prod' and the parameter would put in the corresponding hostname into the M code.