Report Prematurely Adjusting to Next Day

[Anonymous]

Hi All,

I have a Premium Power BI Workspace Report set up with filters for 'Last 1 Day' (i.e. today) and it serves as a "live" data-feed at half-hour refresh increments: 7AM to 11:30PM. Problem being that around 8PM the report is prematurely changing to the next day as if there were a time-zone issue. I've checked my dataset refresh and it is set at EST correctly. Is there some other location that the report would be drawing this from?

Thanks

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

Power BI is a cloud service, and that means Power BI files are hosted somewhere. Some DAX functions such as Date/Time functions work on system date/time on the server their file is hosted on. So If you use DAX functions such as TODAY() or NOW() you will not get your local date/time, You will fetch server’s date/time.

You can follow the methods in  https://radacad.com/solving-dax-time-zone-issue-in-power-bi to solve dax time zone issue.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[zwyatt]

I've been searching for a solution to this same problem all day and i keep getting this same answer as posted here.  However, the answer and the linked article ALL seem to based on reports using NOW() or TODAY(), etc. 
My report(s) do not use those.  They're mostly sales/production reports pulling data straight from SQL via queries, etc. 
I've mostly used my own date intelligence tables primarily to make all Prior Wk/Mth, WTD, MTD, etc easier to manipulate.  

If the majority of the Sales Report(s) date range(s) are being determined at the SQL level, how can I still adjust these reports to properly shift over to the next day at midnight, instead 7pm (my company is in Central Time Zone). 

Do I try and manipulate the date columns coming in? Do I manipulate my Date/Time Intelligence tables? 

I could really use some guidance, or a point in the right direction other than how to replace NOW & TODAY, etc. 

Thanks, 

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

Power BI is a cloud service, and that means Power BI files are hosted somewhere. Some DAX functions such as Date/Time functions work on system date/time on the server their file is hosted on. So If you use DAX functions such as TODAY() or NOW() you will not get your local date/time, You will fetch server’s date/time.

You can follow the methods in  https://radacad.com/solving-dax-time-zone-issue-in-power-bi to solve dax time zone issue.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Sumanth_23]

hi @Anonymous - Are you aware of the location of the Power BI server? It would seem that the server maybe be setup in UTC timezone. Are you using TODAY() or NOW() functions in your measures - this could also cause an issue with your reports. 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks! 

[Sumanth_23 · Accepted solution]

hi @Anonymous - Also a method to workaround this is issue is to use DAX method UTCNOW() and add/subtract a specific number of hours to display report in specific timezone rather than using NOW() or TODAY()

So for example it would be UTCNOW()-8/24 to move the date time to Pacific timezone 

https://docs.microsoft.com/en-us/dax/utcnow-function-dax

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!