Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 pm
Refreshed 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 time
Solved! Go to Solution.
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi 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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI found the solution.
Thanks @MFelix for the reference material.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
140 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
209 | |
92 | |
62 | |
59 | |
56 |