Forum Discussion
Super UserDate format in service changes when using Direct Query
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
Super UserHi 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.