Forum Discussion

harazawana's avatar
harazawana
Regular Visitor
2 years ago

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, the investigation days is not updated as per power BI desktop. 

Example

 

if Todays date is 4th October 2023 , Received Date = 1 Oct 2023

Hence, DATEDIFF = 3 days

 

If  Todays date is  5th October 2023 , Received Date = 1 Oct 2023

Hence, DATEDIFF = 2 days

 

However, When I view the dashboard on 5th October,

 DATEDIFF = 2 days in power BI desktop BUT

DATEDIFF = 3 days in power BI server

 

The TODAY ()  date is not updated in the dataset in power BI server. anybody has the formule to ensure the dataset always updated as in power BI desktop?

 

thank you. 

 

Need Help
Tutorial Requests

1 Reply

  • littlemojopuppy's avatar
    littlemojopuppy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi 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...