Date and time Changes After I import Data into BI Desktop

[Anonymous]

Hello

When I import data from the D365 source application to the BI Desktop, the date and time changes.

Example: the record in the application shows create date as = 2024-09-30 11:54PM

When i import the data into the BI Desktop, it changes to 2024-10-01 5:54:45am

Please how can I correct this because it is affecting the KPI results.

[Anonymous · Accepted solution]

So i have solved this creating a custom created on column using the query below to remove 6 hours from the time

= [CreatedOn] - #duration(0, 6, 0, 0)

[lbendlin]

Hopefully your locations don't use DST.

[lbendlin]

Make sure your data source accurately represents all datetime values as UTC.

[Anonymous]

I have used Locale but it doesn't solve the problem. Question is, how can i correct the data to show exact same as the time from the application?