Date values are changing after the schedule refresh is completed

[WinterGarden]

Hi,

My data source is a sharepoint list , this table has a date column. But the date column is not displaying the correct values when i loaded it into the powerbi. For eg if the date is 1st june 2024 in the sharepoint list it is showing 31st May 2024 in powerbi.To resolve that issue i changed the type with locale as below screenshot. 

Apart from that i changed the regional settings of the file to English Us as well.

After this, i am getting correct date values and when i test the values in the desktop file it is working fine but if i view the report in service it is showing the incorrect date ie it is reverted back to 31st may instead of 1st june. Facing this issue when i view the file after schedule refresh is completed.Does any one know the solution for this issue.

[audreygerred · Accepted solution]

Hi! Power BI Service runs on UTC.

This article may help to achieve what you are looking for: Converting UTC to local datetime in Power BI – Cloud BI

[WinterGarden]

Hi @audreygerred ,

This resolved the issue.Thank you so much !!

[audreygerred]

You are very welcome!