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 >...