Date wont display after 8 pm

[PBI5851]

I have the weirdest issue which I cant figure our for the life of me. My reports run fine without any issue, but in the evening, i get no data so while troubleshooting, i thought there might be a regional setting EST, PST, UTC etc.. so i tried this. My DB is in UTC, i'm in EST though. 

Now, i just cant figure out what is happenning. In the morning, i do the same and i get the current day's value. Anybody else seen this peculiar behavior. 

[amitchandak]

@PBI5851 , is that you report is filtered on today and because of time zone setting it changing the day and you have no data.

Check the timestamp yoy are getting and your power bi timezone.

https://www.youtube.com/watch?v=M1zquwmpnZE

https://community.powerbi.com/t5/Desktop/Date-Field-Time-Zone-Fix/td-p/402509

refer:https://support.helpshift.com/kb/article/how-do-i-set-my-timezone-in-power-bi/

[PBI5851]

@amitchandak Interestingly, when i do a now() function, i get the correct date and time as per my timezone. 

So looks like the power BI is set to my timezone. But does it matter that the database is set to UTC. Because the visuals are set to run with a date of Today()-1.  So even in the evening, PowerBi should be firing a command saying get data for today -1 (10/23 -1 which would be 10/22).

[PBI5851]

Any recommendations on how to resolve this ?