Solved

Excel Power Query Allow User to Input any Number on Parameter

Posted on 2016-11-16
2
29 Views
Last Modified: 2016-11-17
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,

Mike
0
Comment
Question by:Michael Graham
2 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 41891647
Give this article a whirl > Microsoft Excel & SQL Server:  Self service BI to give users the data they want

How to hotwire Excel to a SQL Server Stored procedure, with user-selectable combo boxes fed into parameters.   Requires some VBA coding.
0
 

Author Closing Comment

by:Michael Graham
ID: 41892266
Thank You Jim.  This article really helps and seems to be the only way to accomplish this now.  With the research I have done (because this is a relatively new feature) it seems Microsoft may make it simpler to do this in future releases but for now it is more time consuming.

I hope all is well,

Mike
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now