Forum Discussion
Datamart Incremental Refresh is Failing
I also tried changing the refresh period for different values, and the datamart is spontantenously updated (deleting old data) even without a refresh.That is working as designed. Any meta data change will result in a reset of the incremental refresh partitions and a rebuild on the next refresh.
Incremental refresh is for import mode only. (Small exception when you have a "live" "today" partition that is working in Direct Query)
Do not use the same column for change detection. Use a "Modified Date" column, or don't do change detection at all.
Thanks for your reply. I tried disabling the "Refresh Changed Data" option, but it didn't solve my issue.
I also tried changing the refresh period for different values, and the datamart is spontantenously updated (deleting old data) even without a refresh. Could it be the storage mode? I can see there are three options for storage: direct query, import, and both. But I am not able to change it from "direct query"
I also tried changing the refresh period for different values, and the datamart is spontantenously updated (deleting old data) even without a refresh.That is working as designed. Any meta data change will result in a reset of the incremental refresh partitions and a rebuild on the next refresh.
Incremental refresh is for import mode only. (Small exception when you have a "live" "today" partition that is working in Direct Query)
Thanks for clearing this up. But why the storage mode is not allowing me to switch to "import" mode? Is there any restrictions on the refresh schedule or something else that have to be met to be able to use "import" mode?
In my use case, the datamart loads the data from another dataflow. And it seems like dataflows as a source don't support that storage mode even with the three storage modes are still showing as valid options.