Tabular Editor 2 Error Occured during deployment: Type mismatch

Hi Bi2thelly 

The "Type mismatch" error in Tabular Editor typically indicates that there's a discrepancy between the data types in Power BI and the data model used by Tabular Editor, even if they seem to match visually. Here are a few steps to troubleshoot and potentially resolve this issue:

1. Double-check Data Types: Even if the data types appear to match, sometimes a small mismatch can cause this issue. Verify the data types in both Power BI and Tabular Editor. For example:

   • Ensure that Whole Number in Power Query is truly interpreted as Int64 in Tabular Editor.
   • Check if Text fields are fully consistent and ensure no fields have mixed data types.

2. Reapply Data Types in Power Query: Sometimes reapplying data types in Power Query and refreshing the dataset can fix underlying conversion issues. Select each column with a suspected mismatch, change its data type to something different, then switch it back to the intended type. Refresh and save the model.

3. Column Names and Spacing: Make sure there are no extra spaces or formatting inconsistencies in the column names. Sometimes spaces or invisible characters can cause issues during deployment.

4. Use Explicit Data Type Conversion in DAX Calculations: If there are any calculated columns or measures in Tabular Editor that rely on these fields, add explicit type conversion using DAX functions like INT, REAL, BLANK, etc., to ensure the correct data type.

5. Check Tabular Editor Compatibility: Since you’re using an older version of Tabular Editor (2.25.0), consider updating to the latest version if possible, as some compatibility issues might be resolved in newer versions.

6. Clear Model Cache: Occasionally, old cache files can cause unexpected errors. Try clearing the cache in Power BI and redeploying the model.

If none of these steps resolve the issue, you may want to attempt a fresh deployment by saving a new version of the model with minor adjustments and trying again, or using Tabular Editor 3 if you have access to it, as it sometimes handles deployment issues more effectively.