Power BI not taking time format settings from excel

[amilcrrr]

Hi Team, 

I've built a timeline with date and time hh:mm:ss in excel, but when visualizing the data in Power BI it's defaulting ALL the seconds back to zero. 

Excel 

Power BI 

OR 

I've used ALL these different time format settings,  but it still wont pick up the seconds coming from excel file 

Any ideas? Let me know if you need additional details. 

[Anonymous]

Hi @amilcrrr ,

I notice that the time in the desktop is missing the seconds part, have you converted it in PowerQuery? Please check that.

Then format the datetime column using code like this:

mmmm-dd hh:nn:ss

Output:

The test file is attached for reference. If this does not work, please feel free to contact us.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[amilcrrr]

There might something else going on. I've updated and change ALL the formats above but its doesn't inherit the second still 

[PhilipTreacy]

@amilcrrr 

Please provide your source data and the file with the issue.  Much easier to check what's going on then.

regards

Phil

[PhilipTreacy]

Hi @amilcrrr 

I can't reproduce the issue.  When I load the table from Excel the seconds are preserved 

Importing

In Power Query

In Power BI

Here are my sample files if you want to check them out

PBIX file

Excel file

Regards

Phil