Forum Discussion
Incremental refresh causing duplicate rows
Hello, I've implemented incremental refreshes on one of our fact tables, called 'Transactions'. I can see on a given day there's been a change to some rows, and when this dataflow is consumed...
The moment I use Created Date for incremental refresh, when i publish to service, the frist refresh goes on for hours and gets timed out and fails. I tried that couple of times.
Read about bootstrapping. You can prepare the partitions without filling them. Then fill them one by one.