Forum Discussion
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)
Thank you for your reply ibarrau.
I tried your method, and created source calendar with dates in integer format 'YYYYMMDD'. In PQ I'm setting column format to 'Date' (standard DD/MM/YYYY, just like OS regional settings), and loading both tables to data model. Then I'm creating relationship and publish file to Workspace, and everything works fine. After refresh 'on demand', all dates in matrix are formatted to MM/DD/YYYY, messing all the quantitative values.
Maybe exporting fact tables with date as integer would help, but it would be too tedious, cause I've plenty of sources with date columns formatted as DD.MM.YYYY
First screenshot is after publishing, and second is right after refreshing dataset.
Changing language in PBI Service from English to native doesn't work, same with unmarking all "Relationships" options in file "Data load" category.
Im honestly out of ideas, why it happend at the beginning of new year.
Nothing changed, wasn't installed or updated, whole thing just stopped working out of nowhere...
Hi, cezart
This is so weird. On the forum side, it's hard to provide any more support about this issue.
I would suggest you create a support ticket in Power BI Support to get further help. MSFT engineers may find more information in logs.
Best Regards,
Community Support Team _ Eason
