Forum Discussion
Date formatting changes after scheduled update
Using the FORMAT function I was able to format a date correctly and upload it to the Report Server.
However, after performing the scheduled update it returns to the system default, even if the FORMAT function is there.
My formatting: 15/01/2020 23:55:40
Standard formatting after scheduled update: 01/15/2020 11:55:40 PM.
I don't see how to fix it because the FORMAT function works correctly, it is the server that changes after updating.
Hi , Anonymous
Are you referring to Power BI Report Server incorrect date formats?
This may be caused by the browser’s internal locale settings, such as google and bing, both of which use US settings by default.
You can check the solution in this related document.
https://www.linkedin.com/pulse/fixing-incorrect-date-formats-power-bi-report-server-when-selvakumar
Best Regards,
Community Support Team _ Eason
6 Replies
- aj1973
Community Champion
Hi Anonymous
What mode are you using to connect to the source?
- aj1973
Can I see your FORMAT function please!
Note that some DAX formulas are not supported in Direct Query or Live connection mode.
So I am Guessing that Report server Format is prevailing.
- v-easonf-msft
Community Support
Hi , Anonymous
Are you referring to Power BI Report Server incorrect date formats?
This may be caused by the browser’s internal locale settings, such as google and bing, both of which use US settings by default.
You can check the solution in this related document.
https://www.linkedin.com/pulse/fixing-incorrect-date-formats-power-bi-report-server-when-selvakumar
Best Regards,
Community Support Team _ Eason
