I am trying to build a Power Query Parameter in Excel. I have already pulled my data from a SQL database and selected 4 Columns to Use in that table:
ID| Description| Description_2| Description_3|
An Example of 2 rows would be
123| Advil| Advil 20| MG|
352| Tylenol| Tylenol XR| Caps|
The ID can be thousands of values (numbers only all the same length and type). The other fields are all text fields. I want the end user to be able to enter any single ID and get the 4 columns returned to them.
Any help would be greatly appreciated,