Forum Discussion
Power BI not taking time format settings from excel
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.
4 Replies
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
Regards
Phil
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:ssOutput:
The test file is attached for reference. If this does not work, please feel free to contact us.
Best Regards,
Gao
Community Support TeamIf 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
There might something else going on. I've updated and change ALL the formats above but its doesn't inherit the second still
Please provide your source data and the file with the issue. Much easier to check what's going on then.
regards
Phil
