How to run incremental refresh with unix timestamp

[FilipK]

I wonder how it's possible to run an incremental refresh when I only receive the unix timestamp in ms.

There are a lot of ways how convert the timestamp for sure but I've just seen solutions that are not foldable.

Who can help out?

[amitchandak]

@FilipK , there was a blog around the date key, see if that can help

https://www.fourmoo.com/2020/03/11/how-to-configure-incremental-refreshing-in-power-bi-with-datekey-...

[FilipK]

@amitchandak , thanks for your reply. 

I'm afraid this doesn't work since the relation with unix timestamp between the epochtime and the date in date format is more complex than this:  (x as datetime) => Date.Year(x)*10000 + Date.Month(x)*100 + Date.Day(x). With the unix time there are much more rules to consider.

As you can see here the calculation written in C is not that easy.