Forum Discussion
Incremental Refresh DB2 transactions, no date field
I am working with a dataflow based on operations transactions from DB2. There are no date/time fields - the date is stored in 4 fields: CT, YR, MO, DY. Does this rule out the possibility of doing incremental refresh?
Hi Anonymous ,
The incremental refresh for dataflow needs a date time field , see more detail:https://docs.microsoft.com/en-us/power-bi/service-dataflows-incremental-refresh. So you may need to get a date time field from the existed fields in your data source first of all.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
v-xicaiCommunity Support
Hi Anonymous ,
The incremental refresh for dataflow needs a date time field , see more detail:https://docs.microsoft.com/en-us/power-bi/service-dataflows-incremental-refresh. So you may need to get a date time field from the existed fields in your data source first of all.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.