Power BI Template app query parameters

Question

Hello everyone, recently i created template app with simple list of values parameter and it works perfectly fine on installation however when i switch this parameter from list of values to query (result of the query is list as well), nothing happens and it seems its not supported yet but i cant find this limitation in documentation. Can somebody explain this behaviour?

Note: query parameter works in power bi desktop and dropdown is populated with query result

djordje369 · Answer

Hi again and thanks for replying. Only configuration i can do in template app is to set current value that user can&nbsp;override on installation but i don't want from user to type in input parameter, I want predefined dropdown with values and then let user to choose what to use as parameter which is issue in this topic..

expiscornovus · Answer

Based on my test setup it looks like it might not be supported. My text query parameter Environment (with suggested values from a query) only shows a text input and not as a dropdown list when I install the app.&nbsp;So, I can reproduce your behaviour.&nbsp;In my example I used example Input (so the current value in SANDBOXPI but the user get the suggestion of PRODUCTION and only has to press next). This might be a workaround if you only have a list of two values?

expiscornovus · Answer

Hi&nbsp;djordje369,&nbsp;Just to double check, what type of field are you using? Is it a text field or a different type?&nbsp;Can you share a screenshot of your query parameter setup? That would help troubleshooting.&nbsp;I am assuming you followed the steps of this article? (Might be worth double checking the steps).https://learn.microsoft.com/en-us/power-query/power-query-query-parameters&nbsp;

djordje369 · Answer

Hi, yes i use text field as output and i followed documentation. Somehow on installation wizard of template app i get parameter as simple input and not populated dropdown.. I will also include image of parameter in Power BI Desktop.Query ParameterQuery that retrieves environments