Datatype conversion failed in Tabular model

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?

March 27th, 2015 3:54pm

Hi Kenny_l,

According to your description, you fail to convert a date type data in SSAS tabular. Right?

In Analysis Services Tabular, the default date time format is "mm/dd/yyyy 12:00:00 AM". If you have change the data format for your column, it can't recognize date format form Excel. Please change the Data Format in column Properties window. If the issue still persists, you need to change the format in Excel before importing data.

Reference:
Set the Data Type of a Column (SSAS Tabular)

Best Regards,

Free Windows Admin Tool Kit Click here and download it now
March 29th, 2015 9:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics