Power BI changing the format of excel data when uploaded

[franco2]

In my excel file I have columns formatted only with time hh:mm:ss.

When I upload the file to power Bi it adds a random date.

Is there any way to make power BI just pick the time or take the values of the excel file as it is.

Thanks

[audreygerred]

Hi! In Power Query, you can choose the Time format instead of Date/Time or you can split the date and time, format the time as time and delete the date column since you don't need it.

[nsexton12 · Accepted solution]

Yes! You just need to go to Power Query (Transform Data) or the Table view in Power BI and change that column type to "Time" only. It is defaulting to Date/Time which is unnecessarily adding that date. The screenshot I have attached is from the Table view.

[franco2]

One question that it just came to my mind. If I update the table with a new excel file, will I need to set up the format again in the table?

[franco2]

Thnak you! I'm still new to power BI and didn't it was this easy.