Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |