Power Query Simple Parameters

[testsubjec]

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.

 

[sandy666]

try to adapt this one

s666-PQ-Calendar2.xlsm

Microsoft Excel Workbook

1drv.ms

 

[testsubjec]

Thank you Sandy.

 

[sandy666]

You are welcome