Forum Discussion
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...
hey there,
what values did you use and what version of Excel are you using?
I might try loading this in multiple formats to see if it will work, PowerBI is truncating the real length of the decimal datetime value from excel.
blopez11
Super User
Super UserI tried the value you had in your initial comments, and I am using Excel 2016