Why does power bi add dates to my time column?

[Anonymous]

I am trying to import data from excel and power bi adds date's to my time column which has a format hh:mm: ss and the dates are different from the dates of my date column.

How can I only import the time(hh:mm: ss)

[PattemManohar]

@Anonymous Please post the sample data to replicate your issue

[Anonymous]

The first image is my source file and the second one is when I try to import it to power bi.

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

In Query Editor, you can change the data type to time directly.

Regards,

Frank

[v-frfei-msft]

Hi @Anonymous,

Also you can make the option "Automatically detect column types and headers for unstructured sources" inactive and import the data agian.

Regards,

Frank

[v-frfei-msft]

Hi @Anonymous,

Does that make sense? If so, kindly mark the answer as solution to close the case.

Regards,
Frank

[Anonymous]

Hi @Anonymous

Change the datatype of Tid(UTC) from date/time to time under the modeling tab in ribbon pallet.