Hi,
I am working on a power query report, based on QAD erp data tables using ODBC connection. I am using filters already on the source to optimise load time (mainly date, domain etc.).
Here is an example:
SELECT op_date,op_qty_comp,op__dec01,op_emp FROM PUB.op_hist WHERE op_date > '01-01-2021' WITH (NOLOCK)
This is working great, but my goal would be to change this date from the excel table itself before updating the file. I have no ideea how could I use the excel date as a reference on the data surce.
I would be thankful for any help.
Thanks.
I am working on a power query report, based on QAD erp data tables using ODBC connection. I am using filters already on the source to optimise load time (mainly date, domain etc.).
Here is an example:
SELECT op_date,op_qty_comp,op__dec01,op_emp FROM PUB.op_hist WHERE op_date > '01-01-2021' WITH (NOLOCK)
This is working great, but my goal would be to change this date from the excel table itself before updating the file. I have no ideea how could I use the excel date as a reference on the data surce.
I would be thankful for any help.
Thanks.
Last edited: