SSAS Tabular Model

Question

Hi Friends,

We have a SSAS Tabular Model where the source is SQL Database. While refreshing the data from SQL to SSAS Cube having data issue for one of the field(Formula). Can any one of you advice what need to be done to fix the issue.
]2

Thanks in advance

Answer 1

Hi @Santosh Kumar ,

Welcome to Microsoft Q&A!

What is the data type of column 'formula' in SQL Server and SSAS? And have you get any error message while you refreshing the cube?

If you find that your data has a wrong data type, or at least a different one than you wanted, you have several options:

• You can re-import the data. To do this, open the existing connection to the data source and re-import the column. Depending on the data source type, you might be able to apply a filter during import to remove problem values.
• You can create a DAX formula in a calculated column to create a new value of the desired data type. For example, the TRUNC function can be used to change a decimal number to a whole integer, or you can combine information functions and logical functions to test and convert values.

Please refer to Set the Data Type of a Column to get more information.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.