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

Hi KNP ,

The current Power bi service does not support DateTime values with the specific time zone. We will also feedback this issue internally.

Please check if this thread helps：

Solved: Last Refresh Date change Timezone - Microsoft Fabric Community

Best regards.
Community Support Team_Caitlyn

Thanks for the reply.

That link has nothing to do with this issue.

Also, I should have mentioned above, Dataflows do not suffer from this issue. Once a scheduled refresh is setup for a Dataflow in a timezone, the timezone is respected and refreshes will pick up the current days data irrespective of the time.

The issue is Datamart incremental refresh is not working this way and I cannot get today's data until after midday no matter what I do.

This is a bug.

I am having the same issue on a dataset, I am currently in UTC+7 and suddenly we see that the refresh that we normally do at 6.30am will not contain today's data. when checking the partitions on the table we see that no partition is created for today until we pass 7am. 

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.