Forum Discussion
Scheduled Refresh Failed due to Type Mismatch Error
My semantic model failed it's schedueld refresh and the error message states: "The following system error occurred: Type mismatch. Table: XXX."
When I refresh the Desktop File there are no issues with the refresh.
The other questions and answers I've seen for the type mismatch error always include a specific column that is causing the issue, but what could be causing the issue if no column is mentioned in the error and just a table.
This table XXX is pulled in from an Excel SharePoint site.
3 Replies
- GilbertQ
Super User
Hi Texasaurus
Can you please confirm that you have installed the latest version of Powerbr desktop and then re-published the semantic model?
Hi Texasaurus ,Hello GilbertQ , thanks for your prompt reply!
A type mismatch is usually when a field is of a certain type and some data in a column is not of that type.
Please go back to desktop and check if you have any column type is “Any”.
If there is a date/time column, also check that the values in that column are all valid values.
Similar issue for your reference:
Type Mismatch Error - Microsoft Fabric Community
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Texasaurus,
I'm checking how the things are going on about this issue. Whether the answer helps you?
If there is any problem, please feel free to let me know.
