Hi DAX Experts,
I have faced the below issue while inserting records into a Table.
Cannot create a record in Table. The SQL database has issued an error.
While Synchronizing the table i got a below Error.
Unable to convert data types to anything but character field type (0 to 4).
Note: I have resolved this issue using below resolution steps. But make sure that i have done this under UAT environment. If it is in Live then take a necessary backups before doing any changes under table. Also make sure that i have done this in customized table.
Resolution:
-
Select Error table from AOT.
-
Select particular column name from the table(which you got that while synchronizing the table).
-
Delete the particular column from table.
-
Save and compile the table.
-
Synchronize the table.
-
Add the deleted column to the table.
-
Save and Compile the table.
-
Synchronize the table which will not show any errors.
-
Try to insert the records into the table.
-
You have Done [emoticon:c4563cd7d5574777a71c318021cbbcc8]