On demand refresh issue

Hi, Since new year, I’m experiencing problems with “On demand” refresh on PBI Web Service. Issue occurs in old Datasets and also in new ones, just published to Premium Workspace. Sample data model ...

Need Help

cezart

Frequent Visitor

4 years ago

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...