KNP's avatar
KNP
Icon for Super User rankSuper User
3 years ago
Status:
Investigating

Datamart Incremental Refresh not updating current day based on my time zone

I have incremental refresh setup on a Datamart.     My timezone is UTC +12 currently. When the scheduled refresh runs it does not pickup the current days transactions until after midda...
Data Modeling
KNP's avatar
KNP
Icon for Super User rankSuper User
3 years ago

Hi PierreL,

 

I went through the support process with them.

The workaround currently is to add a column by converting your date time column to UTC.

Something like this...

 

Table.TransformColumnTypes(
    Table.AddColumn(
        PreviousStep, 
        "YourDTColumnUTC", 
        each [YourDTColumn] - #duration(0, 7, 0, 0)
    ), 
    {{"YourDTColumnUTC", type datetime}}
)

 

Then use this new column for your incremental refresh.

 

Hope this helps.

 

Completed Ideas