Power BI Template app query parameters

[djordje369]

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

[Expiscornovus]

@djordje369,

I tried to recreate what you had. With the below setup it seems to accept my value when installing the app and filter for rows from my other query (in my example I used a table which is called issues and uses the environment parameter to filter the rows).

Similar parameter

Current value parameter

SelectRows example which uses the parameter (which is used in a table visual).

Template App parameter setup

Connect your data

Value for the Query

Report with Production data (based on that query parameter)

[Expiscornovus]

Hi @djordje369,

Just to double check, what type of field are you using? Is it a text field or a different type?

Can you share a screenshot of your query parameter setup? That would help troubleshooting.

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

[djordje369]

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

[Expiscornovus]

Thanks for sharing these details. How did you configure that parameter in the template app itself?

[djordje369]

Hi again and thanks for replying. Only configuration i can do in template app is to set current value that user can 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]

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.

So, I can reproduce your behaviour.

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?

[djordje369]

Yeah i think its not supported too. It wont execute the query and everything we got is input parameter. I am not sure why Microsoft didnt document this limitation.. Thanks for your help, i will stick with input parameter because its working fine for me but it would be way easier with queries..