Date format in service changes when using Direct Query

[zenisekd]

Hi, 
I have my reports, and they seem to be displaying the correct format, when it comes to import (DD.MM.YYYY) both in Desktop and Service. When it comes to Direct Query, I see the date correctly in the desktop (DD.MM.YYY) but in service it goes wild to "MM/DD/YYY". Not only changing the "." to "/", but also switching days for months, which is anoying. 

Could anyone advise? thank you. 

[Anonymous · Accepted solution]

Hi @zenisekd 

You can try the following:

• Modify the date format in the model view with custom format

• Ensure that the locale of the browser used by the service is the same as the locale set by the desktop. Or modify the language setting of the service. 

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[zenisekd]

Hi @Anonymous , 
I don't consider either as the best solution, I would expect that that the format should be the same as in the import mode if all settings remain the same. 

Anyway, modifying the model dates work, but it is a lot of manual work 😕
Modifying the service language settings works as well, but it is not suitable, because every user would have to do that. 

I don't quite understand, does import differ from the Direct Query... 

Anyway, I went with the manual formatting option. Thank you.