Forum Discussion
Date value is changed when visualized from a dataset
It seems to me that you are victim of a 'feature' of Power BI Service. The PBI Service might use a different timezone then you are and you cannot change the timezone of the service. So, if you are pulling in a datetime of 1/1/2019 23:00:00 local time, it might be converted to the local timezone of PBI service when returned to you in PowerBI Desktop (when you connect to it as a dataset) to for example 2//2019 02:00:00.
I can recommend this article for possible solutions:
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
djerro123:
Thanks for your comments.
I can understand the behavior of DAX functions like TODAY() or NOW() when are published in Power BI Service but in this case the date that is changed comes from a table (as a data), I mean, it is not the result of a buil-in function. I expected the data must be respected as it is (no changes at all).
Anyway, I will try your recommendation as a possible solution.
Best regards,
Mafe62