cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DavidBenaim Frequent Visitor
Frequent Visitor

Parameter from Excel list not giving drop down menu (seems like a bug)

I want to have a cell/list in Excel which is the source of a parameter, so the user can overwrite the Excel cell and then change the folder path to extract data from. I get the same issue if I make a new query from PowerBI Desktop and from excel's Power Query.

 

When I create the data in excel> Convert to table> New query from there>Drill down query (to make it a list)> New parameter & choose this list. It doesn't give me a drop down, it seems to completely disregard the fact that I have a query set as the parameter and act as a free type text box. Either I am missing something or this is a bug. Any suggestions?parameter from query bug.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft Phil_Seamark
Microsoft

Re: Parameter from Excel list not giving drop down menu (seems like a bug)

Hopefully the ability to set parameters from the Web Service will appear soon.  This could be very handy.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
MarcelBeug Super Contributor
Super Contributor

Re: Parameter from Excel list not giving drop down menu (seems like a bug)

You will get a dropdown list if you change the parameter via "Edit Parameters".

 

Otherwise I agree with you: it is strange that a dropdown is not available for "Current Value" on the "Manage Parameters" screen.

Specializing in Power Query Formula Language (M)
Microsoft Phil_Seamark
Microsoft

Re: Parameter from Excel list not giving drop down menu (seems like a bug)

Hopefully the ability to set parameters from the Web Service will appear soon.  This could be very handy.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

DavidBenaim Frequent Visitor
Frequent Visitor

Re: Parameter from Excel list not giving drop down menu (seems like a bug)

Thanks, yes I checked the "Manage parameters", and just clicking the "parameters" option, but not gone to the "Edit parameters" one, that does seem to work - thanks. 

 

I do think its something that was forgotten about in the user interface though!

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors