Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Import Dates from Excel - Seconds

Hi,   I've been importing dates with seconds from Excel, I need a process which doesn't have any manual fixes.   When I import date everything import fine, apart from the seconds. They are all de...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I can't attach a screenshot.

 

But the example is that

 

23/12/2019 23:12:12 imports as 23/12/2019 23:12:00

 

This happens for the whole file. However Power BI does know its a date and time stamp. 

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous ,

By my tests with the latest version of power bi desktop, I cannot reproduce your scenario.

Please check if you have installed the latest version of power bi desktop(2.71.5523.941).

In addtion, what data type of your date column in Excel file? Please set with Date type.

If you still need help, please share a sample excel file which could reproduce your issue so that I could have a test on it.

Best  Regards,

Cherry