Forum Discussion
Date Changing When Published To Service - despite coding it out with dax
Hi everyone,
While I have had this same issue before, the previous solution doesn't seem to be working.
My database (CDS) stores dates in UTC timezone, and I am in AEST (+10). While it displays correctly in desktop, when I publish to service the timezone changes to UTC.
Previously, adding a new column for local date using DAX (i.e UTC + 10/24) solved the problem. This time, however, it seems to be still displaying in UTC... I have also tried adding a new local time column in power query, with the same result.
Have there been any changes to the software that would change this? Or have any of you found another workaround?
Thanks!
6 Replies
Hi lbendlin ,
Yes - I used DAX to add a new column with the adjusted date, when that didn't work, I used the local date function in power query to create a column from examples with the local time..
Hi ashleylinkewich ,
Could you pls take a screeshot of your custom column about converting to the UTC time and what is showing in Service?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
