Slow incremental refresh using days

[FredrikJ]

Hi!

We have a problem using days to partition our incremental refresh, it works but the refreshes are very slow.

When the incremental refresh is loading data for the last 2 days it takes 15-20 minutes for the Refresh. If the partitions are om month and we do an incremental refresh on the same dataset and same table, loading data for the 1 month, the refresh takes about 3 minutes.

Regards 

Fredrik

[FredrikJ · Accepted solution]

Hi!

The problem was caused by a strange behavior in the view back in our Oracle soure.

/Fredrik

[v-easonf-msft]

Hi, @FredrikJ 

If the issue is resolved, you can accept a reply as the solution to close this thread.

If you still need help, please feel free to ask.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi, @FredrikJ 

What does your partition roughly look like？Have you made any other settings changes?

Please share relevant screenshots of the configuration page.

Best Regards,
Community Support Team _ Eason