problem with actual time in refreshing

[sandragocj27]

Hi Everyone, 

I have made a simple dashboard that shows a column with the value now(), but when I publish the report and I refresh it, the hour I get is now - 2, why?? any Idea? 

[sandragocj27]

[v-sihou-msft · Accepted solution]

@sandragocj27

Since Power BI Service is cloud service, your .pbix file will be hosted on cloud cluster server so that TODAY() or NOW() will not return your local time. You can use Power Query functions to get the correct datetime. Please refer to blog below:

Solving DAX Time Zone Issue in Power BI

Regards,

[sandragocj27]

thanks!