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/
collinq
Super User
Super UserHi 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