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...
blopez11
Super User
Super UserI just tried this, and PowerBI seemed to recognize as DateTime format
In my Excel, I had to use the custom format: m/d/yyyy h:mm:ss AM/PM to get it to show up like yours
I'm not sure why its not recognizing in your case
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
I tried the value you had in your initial comments, and I am using Excel 2016