Forum Discussion
DateTime in Published Report shows as UTC
- Hi there
This is because all the Power BI Servers have their datetime set to UTC. So when using DAX functions that use NOW() for example it will always be in UTC
This blog post explains this as well as how to get it working for your timezone: https://www.fourmoo.com/2017/10/03/power-bi-did-you-know-all-power-bi-services-servers-are-in-utc-now-how-to-handle-it-for-dates-times/
Super UserAnonymous , refer if this can help
https://support.helpshift.com/kb/article/how-do-i-set-my-timezone-in-power-bi/
- GilbertQHi there
This is because all the Power BI Servers have their datetime set to UTC. So when using DAX functions that use NOW() for example it will always be in UTC
This blog post explains this as well as how to get it working for your timezone: https://www.fourmoo.com/2017/10/03/power-bi-did-you-know-all-power-bi-services-servers-are-in-utc-now-how-to-handle-it-for-dates-times/I have created one dashboard where i have used one date slicer which has format as "DD-MM-YYYY",when i published it then the format got changed "MM-DD-YYYY".How to fix this ?
Can anyone help me on this
Thanks
amitchandak My organization doesn't use Help Shift and we don't have those settings so that link is not helpful. Any other suggestions?
- collinq
Hi Anonymous ,
Here is a solution that might be helpful:
Or this one here:
https://community.powerbi.com/t5/Desktop/Add-UTC-offset-to-client-time/td-p/700640
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
No it's not working.
Query:- I have created my dashboard where i have used date slicer .While working on Power BI Desktop App my date format is in "DD-MM-YYYY".When I Publish my report it changed like this "MM-DD-YYYY".
How can I fix this issue?
Please suggest any solution
Thanks
