Forum Discussion

Maffimau's avatar
Maffimau
Frequent Visitor
9 years ago

Powerbi.com Server Time

Hi, I did a big report with a lot calculation based on now() function (hour, average time for a operation, ecc..). After published the report I dicover that the database are in Irland -2 hours from ...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Maffimau,

 

There is a known gap for the time zone displayed in Power BI Service. The time zone in the service is effectively always set to UTC.

 

For example, if we use NOW() as a measure in Power BI Desktop, it can give the correct time based on your current time zone. However, once you publish to Power BI Service, the time will be adjust to UTC time.

is there a system to syncorize my local time with the server time zone of powerbi so I can see the same time on desktop and on web? I can't change all the calculation on my report because I work with a direct query on sql server that read in realtime the hour and minute.

Based on my test, you should be able to use the formula below to create a new measure for now calculation, and then replace NOW() function with this new created measure [NowFuntion] in all your related formulas. :smileyhappy:

NowFunction =
TODAY ()
    + TIME ( HOUR ( NOW () ) - 2, MINUTE ( NOW () ), SECOND ( NOW () ) )

 

Regards