Forum Discussion
Microsoft Employeedatasource change with parameters
Hi repaaksp,
Based on your description, you need to set a dynamic parameter value to your parameter.
Currently, the available values for a parameter can only from a hardcode list, and parameter value can only be changed manually. For the feature to get parameter available values from a query, I would recommend you submit a feature request in the idea forum: https://ideas.powerbi.com/forums/265200-power-bi-i
deas. Reference
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
http://biinsight.com/power-bi-desktop-query-parameters-part-1/ Regards,
Charlie Liao
Community Championrepaaksp You can change parameter values in pbi desktop by exiting out of query editor (Close&Apply) and then under Home tab -> Edit Queries dropdown -> Edit Parameters.
Microsoft EmployeeYes I know I can edit those myself. But the question is how to make online services choose the parameter itself, depending on which parameter is available
v-caliao-msftHi repaaksp,
Based on your description, you need to set a dynamic parameter value to your parameter.
Currently, the available values for a parameter can only from a hardcode list, and parameter value can only be changed manually. For the feature to get parameter available values from a query, I would recommend you submit a feature request in the idea forum: https://ideas.powerbi.com/forums/265200-power-bi-i
deas. Reference
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
http://biinsight.com/power-bi-desktop-query-parameters-part-1/ Regards,
Charlie Liao
I'm not seeing a solution to your question as I too am having the same issue with the end user being able to change a date parameter once it is published.