Query returns too much data despite date filter

[bengisby]

Hello,

My data set is 1.5million rows, oracle view, taking 20min to refresh. I have done a table join to another table in an attempt to return less data, but every time I refresh it still queries all 1.5million rows. I even try to filter by date >, but it still queries all 1.5 million rows. Am I doing something wrong? 

[v-shex-msft · Accepted solution]

Hi @bengisby,

Join table doesn't direct decrease the refresh amount.
In my opinion, I'd like to suggest your add sql statement to oracle connector to cut down the data amount.

Regards,

Xiaoxin Sheng