Forum Discussion

allens1's avatar
allens1
New Member
9 years ago

DateTime Error - Can't convert decimal number to datetime format (ex. 42126.62708)

Hi There,   Not sure how many folks are experiencing this but I am using a Excel data source for some PowerBI reporting I want to do.   My data in excel is in displayed in this format 5/02/2015 3...
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi allens1,

 

Yes, the decimal number can be converted to Date/Time at the seconds level in this case. However, you need to change the display format from "5/02/2015 3:30:00:00 PM" to "5/02/2015 3:30:00 PM", or just use the decimal format in Excel before loading it to Power BI Desktop.:smileyhappy:

 

Regards

blopez11's avatar
blopez11
Icon for Super User rankSuper User
9 years ago

Thats why mine worked, I had display format of: m/d/yyyy h:mm:ss AM/PM

Good catch