Forum Discussion
HR3038511
Helper I
Helper IDropdown for Parameter not showing
Hi, I created a parameter in Power Query based on list which I generate with another query in Power Query. This list has multiple values hence I would expect a drop down menu for the parameter t...
Sorry for jumping in here, but I believe Power BI Service does support query-based dropdowns for parameters when using "DirectQuery" mode.
We can bind the dropdown column to a parameter and pass the selection—it will work in the service.
Unfortunately, I don’t have a data gateway connected to my service right now to demonstrate an example.
In this video, (unfortunalty he doesn’t publish it to the service), but I have tested this in one of my projects, and it works. https://www.youtube.com/watch?v=pXU_SpiBWUA&ab_channel=DataPlatformCentral
lbendlin
Super User
Super UserDefine what you mean by "users". Parameters can only be changed by the semantic model owner.