I have imported Excel data to Tabular. I have SalesDate column and data looks like '25.03.2015 18:08:05' in Tabular. This column is defined as datetime in Excel. However when I select properites->Data Type->Date I get error. Type mismatch. Datatype convertion failed for table [table...column...Value] |
I don't understand why column is not qualified to be converted to Date format.
How to fix?