Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Time Diff calculation not updating in Power BI Server.

Hi Experts,

I have an issue. I am calculating age in minutes from the date/time (when we logged a ticket). It works in Desktop refresh.

Issue: when the dataset is refreshed in the PowerBI server it is not calculating the age. I am using now() - date/time created as Age.

 

Below 2 images from PBI server.

Refreshed in Power BI at 11.40 pmRefreshed in Power BI at 11.40 pm

Refreshed in Power BI at 11.00 pmRefreshed in Power BI at 11.00 pm

Refreshed data from PBI Desktop. All minutes/ hour data all moved to 1 day as they calculate from created date to my local time. My local time is +11 from UTC.

 

Below image from PBI Desktop.

 

Refreshed in Power BI Desktop at 11.40 pm Local timeRefreshed in Power BI Desktop at 11.40 pm Local time

2 ACCEPTED SOLUTIONS
MFelix
Super User
Super User

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/


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

4 REPLIES 4
MFelix
Super User
Super User

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/


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

@MFelix 

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



I found the solution.

  1. 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.
  2. 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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors