Forum Discussion
Helper IIShould I get a drop-down of values on Current Value for a Query based Power Query Parameter
I build a list to utilize a list query for a parameter as described here. When I go populate a avlue in Current Value box shouldn't I get a dropdown of lists to choose from. See screenshot below
K. I just read the comments in the blog post I referenced in the original post. Turns out there is a bug that prevents the list from creating a drop-down in PQ as shown in the screen shot in the post. Instead, close out of PQ in PBD go to Queries>Transform Data>Edit Parameters and then the drop-downs will be available there.
1 Reply
jmg80525K. I just read the comments in the blog post I referenced in the original post. Turns out there is a bug that prevents the list from creating a drop-down in PQ as shown in the screen shot in the post. Instead, close out of PQ in PBD go to Queries>Transform Data>Edit Parameters and then the drop-downs will be available there.