Day difference between Power Bi Desktop and Web

[Aingeal3010]

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?

[Idrissshatila · Accepted solution]

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