Forum Discussion
DATEDIFF() using TODAY() function not updated in POWER BI Server
Hi, I have used formule using function DATEDIFF from todays date:- Investigation Days =DATEDIFF (TODAY (), Received Date (), Day) However, once the dashboard is published to power BI server...
littlemojopuppy
Community Champion
Community ChampionHi harazawana
Question: when you say "Power BI Server" do you mean the Power BI service? Or Report Server?
The Power BI service always operates on UTC time, so depending where you are in the world relative to UTC time, "today" might not update quite when you would expect.
Not sure if this is true with Report Server...