Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 inc...
Dataflow
  • v-xicai's avatar
    v-xicai
    6 years ago

    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.

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

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.