Date/Time not showing detail

[Tom_G]

Hello, i've imported some date/time data into BI in the format 

YYYY-MM-DD HH24:MI:SS. 

In the Query Editor (in all steps), the data is showing correctly.

Arrival Date	Departure Date
24/03/2018 14:14:50	25/04/2018 04:15:07
16/06/2018 16:09:13	17/06/2018 13:12:15

However, in BI outside the query editor the time part of the data is just showing as zeros (as below) for the vast majority of the data set except a small part - I can't get the time data to display. The column data types are date/time. 

Arrival Date	Departure Date
24/03/2018 00:00:00	25/04/2018 00:00:00
16/06/2018 00:00:00	17/06/2018 00:00:00

 In short I don't know why this is happening. I simply want to display the data as it appears in the query editor.

Let me know any suggestions on how to fix this!

Thanks!

[v-kelly-msft]

Hi  @Tom_G,

Go to query editor>applied steps>Changed Type,removed the content I marked in red:

Then do the following steps:

Right click on the column>Change Type>Using Locale(English Palau):

As tested here,if you directly change the column in query editor to datetime format,it will return errors:

Try the method I provided above to see whether it can solve the issue.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Tom_G · Accepted solution]

Hi @v-kelly-msft, thanks very much for your help. After a lot of head scratching, it seems that the problem was due to one inconsistently formatted csv file that had DD-MM-YYYY HH:MM:SS instead of YYYY-MM-DD HH24:MI:SS. The pbix contained multiple csv's but the inconsistent format within the same column was causing this issue in BI. 

Thanks for your solution I will keep this in mind if I encounter similar issues. Thanks

[v-kelly-msft]

Hi @Tom_G ,

So your issue is solved,right?If so,could you pls mark the reply as answered to close it?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Tom_G , I doubt that can happen unless there is step in power query that is changing the data type to date(only date in power query)