Forum Discussion
Time Diff calculation not updating in Power BI Server.
Hi Anonymous ,
That has to do with the fact that the PBI service uses the UTC time zone, so when you use now that is the hour you will get.
Check the links below with several ways to solved it.
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/
Hi Anonymous ,
Glad you could find the answer, I was only trying to point out the way and help you get new perspective.
When you post the answer don't forget to mark it so it can help others.
Hi Anonymous ,
That has to do with the fact that the PBI service uses the UTC time zone, so when you use now that is the hour you will get.
Check the links below with several ways to solved it.
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/
Hi Miguel, I have found a solution. Though I have gone through Radacad and Excel guru. i have achieved outcome differently. Please wait for a day or two, as i am waiting for the new ticket database update as others send me the data.
I'll update the solution, within 2days.
Regards
Krishna
Hi Anonymous ,
Glad you could find the answer, I was only trying to point out the way and help you get new perspective.
When you post the answer don't forget to mark it so it can help others.
I found the solution.
- As the ticket was raised in local time (which is +10 to UTC). calculation of age was resulting in a negative value (my time was ahead of UTC). Resulting in negative values rolling into time bucket as the time lapsed. Solved with converting local time to UTC and then calculating the age. The values will look different in PBI Desktop, this should be expected.
- Dataset was refreshing, the refreshed report was showing the old values. Solved with refreshing the browser once the dataset/report is refreshed.
Thanks MFelix for the reference material.
