Power Query Simple Parameters

testsubjec

New Member
Joined
Jul 14, 2011
Messages
33
Hi,
Firstly I apologies if this is very simple to do.
We are migrating all our very old Excel spreadsheets which connected to an IBM database mainframe to SQL Server using Power Query. Our old excel spreadsheets have a Parameter Sheet containing up to 15 parameters and we used the "?" within the command text to define the parameter etc. The user set the parameters refreshed the sheet and the query brought back the data into another sheet based upon the parameters.

I need to replicate this behaviour using Power Query, I've played around with Power Query a little but haven't been able embedded parameters. :)

So to keep this simple.... I have a Parameter sheet that allows users to set a From Date ( DD/MM/YYYY ) in Cell A2 and a To Date ( DD/MM/YYYY ) in Cell B2. When the user refreshes I need Power Query to grab the parameters from these fields and the run query. ( In short ).

If someone could offer to assistance on this it would be really appreciated.

Thank you.
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Watch MrExcel Video

Forum statistics

Threads
1,112,814
Messages
5,542,649
Members
410,566
Latest member
Jonniehoffman
Top