Forum Discussion
problem with actual time in refreshing
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?
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,
3 Replies
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,
thanks!
