Solved: Incremental Refresh DB2 transactions, no date fiel...

Anonymous · ‎12-31-2019

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?

v-xicai · ‎01-01-2020

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.

View solution in original post

v-xicai · ‎01-01-2020

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.