Using Tabular Models - SQL Server Analysis Services 2012 Cube Development - page 315

3. It is also important to verify and fix any data types that were not properly iden-
tified during the load. While loading from relational data sources is usually
not a problem, it is a common issue from file-based or feed-based sources.
4. You can change the data type in the Properties page of the selected column.
In the Basic section, you will see the Data Type property, which has a drop-
down list of the supported types.
Note
Tabular Models only support a few basic data types: text, whole number,
decimal number, currency, date, and TRUE/FALSE. The default type is
text and will often be the only type used for text file loads.
5. You can also change the data format in the Properties page of the selected
column. In the Basic section, you will see the Data Format property, which
uses a drop-down list to let you select the correct format and type for the
column.
Note
Always fix the data type before working with the format. Once you have
corrected the data type, the data format drop-down list will display the
valid options for the type.