Using of Parameters (list of values) in the service

[webchris]

Hi all

I have published a semantic model to the service. This semantic model does contain parameters with a list of values.

When I want to adjust the settings / parameters in the service, I do not get the list of values as a dropdown but instead have to manually enter the parameter value (which is kind of error-prone...).

Do you have any good idea to get the list of values shown in the service, without having to open the semantic model there?

Thanks for your input

Christian

[v-vpabbu · Accepted solution]

Hi @webchris,

Unfortunately, this feature is not yet available in the Power BI Service, which currently only allows manual entry of parameter values.

It is possible that this limitation may be addressed in a future update. I recommend submitting your detailed feedback and suggestions through Microsoft's official feedback channels. Feedback shared via these channels is frequently reviewed by the product teams and can help drive meaningful improvements.
https://ideas.fabric.microsoft.com/ideas/search-ideas/ 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

Vinay Pabbu

[Sahir_Maharaj]

Hello @webchris,

Instead of defining a parameter inside Power Query, can you please try creating a detached table with selectable values and use a measure or slicer.

ParameterValues = DATATABLE(
   "Parameter", STRING,
   {
      {"Option 1"},
      {"Option 2"},
      {"Option 3"}
   }
)

SelectedParameter = SELECTEDVALUE(ParameterValues[Parameter], "Default Value")

If you need a way to dynamically update the parameter in the Power BI Service, you can use Power Automate to trigger dataset parameter updates.

[webchris]

Hi Sahir

thanks for your proposal, but that is not what I was looking for. 

I think the dropdown for the parameter with the list of values should be available in the service as well.

Thanks

Christian