Forum Discussion
Time/Date Problem when publishing to Power BI Service
Right, I've cracked it with a help from you two!
You both helped in identifying the issue in terms of the times changing when publishing, so I did research on how to change the time
I used this article: https://natechamberlain.com/2019/08/02/add-or-subtract-hours-from-date-time-values-in-power-bi-using-m-formula-in-power-query-editor/
=[Completion Date] + #duration(0, 1, 0, 0)
I used that formula in the Custom Column section in the Query Editor. I felt that the difference in time wasn't significant so I just change the time so instead of 11pm, it showed 10pm and that gave me the desired result.
The hard thing to understand was that the Desktop version is always going to be wrong because time time/dates change but when I publish it to the service is when the figures become identical to Dynamics 365
hi michael_knight - Glad you got this worked out; I also enquired and there are some reports we have built for one of our customers which is using data from Dynamics 365 but we are not seeing this issue.
I think you should still open a ticket with Microsoft to look into this. 🙂
Also curious to know - did you try the calculated column approach - did that work as expected?
Well this is the really the only time I've seen this issue. Most of the date data we use in Dynamics 365 has Time and Date, but for this instance it's only a date so maybe that's where the issue lies. I'll contact Microsoft anyway and see if it's an issue
I didn't get to trying the calculated column appoach, that was going to be the 2nd thing I tried today but thank god the first thing worked!
Thank for very much for your help, it was much appreicated!
michael_knight - Great! happy to help!