Forum Discussion

Aingeal3010's avatar
Aingeal3010
Regular Visitor
2 years ago
Solved

Day difference between Power Bi Desktop and Web

Hi, I have a dashboard with a column of the last record (using the max function with a date). Happens when I update the dashboard in Power Bi desktop the max date is the real max date, but when I pub...
Need Help
Tips and Tricks
Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

Hello Aingeal3010 ,

 

The thing is that the Power BI service only operates in the UTC time zone, you need to adjust dates & times in DAX or Power Query.

There are lots of resources on this these few may help..

Dynamic time zone conversion using Power BI – The White Pages (unlimitedviz.com)

Power BI Service Time Differences and How to Fix It (linkedin.com)

Showing Current Time and Latest Refresh Time at Local Timezones in the Power BI Report - RADACAD