Date column with auto time added in Power BI - pushing dates to next day

[swathimuthukum]

Hi,

I have date column pulled into Power BI from Dynamics where most of the values matches as they do in the system, but it would seem there is a time stamp of 12:00:00 AM that is pushing 17 dates to the next day rather than the date in the source system. 

Please find the below screenshot from the export for reference:

The date is manually entered in by the user, often back dated, but it seems to have an assigned time in the PowerBi report, either 5am, 6am, or midnight. Those at midnight are logged in PowerBi as the day after the date entered into the system.

Any help/suggestions are appreciated! 🙂 

[v-eachen-msft]

Hi @swathimuthukum ,

You could open query editor and check if date values matched in source step. And try to use "yyyy-mm-dd hh:nn:ss" format.

[amitchandak]

@swathimuthukum , what is the formula you are using to assign time in Power BI

[swathimuthukum]

@amitchandak I am not using any formula for time. it is automatically populating for every date - either 5am, 6am or 12am.