On demand refresh issue

Hi. This is kind of weird. I have seen this error before but for text keys, not numbers formats.

I would suggest to use an integer key between them (mark calendar as date table to make time intelligence work). The integer as "YYYYMMDD" never fails. I usually use just "date" type with regular format and never had issues, but this sounds like it's having an issue with the format and region in service.

I hope that helps,

P/D You can also try remove duplicates (power query step) in the key column in date table just to check if the engine is capturing that before vertipaq (both engines work different)