Forum Discussion
Urgently - Problems with function Today (), in Power BI Service
Hi OzcarHui07
What happens is when you use the TODAY() function in the Power BI Desktop it uses your Local System time to determine this.
When you upload your file to the Power BI Service, what I can gather from testing is that all the Power BI Servers time is set to UTC. So if you are in a timezone that is say -10 UTC, then due to this it is not today, but according to the Power BI Servers showing as tomorrow.
What I suggest you do, is to alter your Today with -10 hours in the Query Editor?So something like this.
TodaysDate = DateTime.From(DateTimeZone.SwitchZone(DateTimeZone.FixedLocalNow(),-10))
Hi GilbertQ
Its perfect, thanks so very much, now i can show without problems.
I resolved the them of UTC, also the zone time.although, only i have created a other column more of Date in the dimension time and it was asignated data type as Data / Time /TimeZone in the edit queries.
Thanks.
Hi OzcarHui07
What happens is when you use the TODAY() function in the Power BI Desktop it uses your Local System time to determine this.
When you upload your file to the Power BI Service, what I can gather from testing is that all the Power BI Servers time is set to UTC. So if you are in a timezone that is say -10 UTC, then due to this it is not today, but according to the Power BI Servers showing as tomorrow.
What I suggest you do, is to alter your Today with -10 hours in the Query Editor?
So something like this.
TodaysDate = DateTime.From(DateTimeZone.SwitchZone(DateTimeZone.FixedLocalNow(),-10))
Hi GilbertQ
Its perfect, thanks so very much, now i can show without problems.
I resolved the them of UTC, also the zone time.
although, only i have created a other column more of Date in the dimension time and it was asignated data type as Data / Time /TimeZone in the edit queries.
Thanks.