Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
franco2
New Member

Power BI changing the format of excel data when uploaded

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

franco2_0-1709220629406.png

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

franco2_1-1709220709338.png

 

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

 

Thanks

 

1 ACCEPTED SOLUTION
nsexton12
Resolver II
Resolver II

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.

 

Date-Time.png

View solution in original post

4 REPLIES 4
audreygerred
Super User
Super User

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.





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

Proud to be a Super User!





nsexton12
Resolver II
Resolver II

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.

 

Date-Time.png

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?

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.