Forum Discussion
DateTime in Published Report shows as UTC
Hello all, I recently noticed an issue with some published PowerBI Reports in various workspaces not showing the correct times. It seems to be happening with reports that have CDS as the data sou...
- 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/
GilbertQ
Super User
Super UserHi 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/
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