Forum Discussion

WinterGarden's avatar
WinterGarden
Icon for Resolver I rankResolver I
2 years ago
Solved

Date values are changing after the schedule refresh is completed

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.