Forum Discussion
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 publish in the Web version and update there, the dashboard shows another date. The source of information of the dashboard is an API, what could be happenning?
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
1 Reply
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