Type Mismatch

[vasSight]

I faced a type mismatch on a table error everytime I plublish the file and try to refresh it using on-premise

tried to strong type types and reconfiguring calculation columns and while testing if I uploaded a file with only that table it refreshes normally 

in the end it turned out that the file itself had an issue, we recreated the issue vanished 

[v-aatheeque]

Hi @vasSight 

We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.

[v-aatheeque]

Hi @vasSight 

Just checking in to see if the previous response helped resolve your issue. If not, feel free to share your questions and we’ll be glad to assist.

[Shubham_rai955]

The type mismatch error when refreshing your report typically occurs because Power BI Desktop is more tolerant with data type inconsistencies than the Power BI Service. Common causes and fixes include:

• Data types in Power Query or source may differ from what Power BI expects during refresh—especially for date/time or numeric fields.

• “Changed Type” steps in Power Query can sometimes assign unintended types, causing mismatches in refresh.

• Power BI Service is stricter than Desktop; it fails if any data values violate expected types.

• Nulls or errors in column data may also lead to type mismatch.

• To fix, explicitly set data types very early in Power Query, eliminate ambiguous type changes, and validate that all data conforms to the expected type.

• Recreating or reimporting the problematic table often resolves hidden inconsistencies.

[Shahid12523]

The type mismatch error during refresh was caused by a corrupted source file. Fixing it by recreating the file resolved the issue. When refresh errors persist, consider rebuilding the source to clear hidden file problems

[Ritaf1983 · Accepted solution]

Hi @vasSight 

To properly diagnose the issue, it would be necessary to review the actual model. Based on the description alone, one common cause of a Type Mismatch error is when certain cells in a column don’t match the overall data type of that column.

Typical examples include:

Empty values that are actually white spaces in a Date or Number column.

Values like "NA" coming from Excel formula errors.

The best practice is to clean or fix these inconsistencies at the data source level before loading the data into Power BI. This usually prevents such errors from appearing during refresh.

If my answer was helpful please give me a Kudos and accept as a Solution.