Forum Discussion
Error: The following system error occurred: Type mismatch. Table:
Hi Anonymous ,
Please try reverting and re-doing the change data type step in power query.
Also please see if this link helps you in identifying the buggy column causing the issue.
https://medium.com/@enridge/how-to-highlight-error-data-in-power-bi-487ef4feca1d
Thanks,
Pallavi
Hi Anonymous ,
Thank you for reaching out to the Microsoft Fabric Community Forum about the issue you are encountering.
Providing the resolution steps which might assist you in resolving the issue:
1.Double-check the fields in the SBZ FE Inventory table, a small mismatch can trigger a type mismatch error.
2.Sometimes Null values in fields may cause mismatch issues.
3.Check the calculated columns and make sure to verify the calculations are properly handling data types.
Attaching the relevant thread which may assist in in addreesing the error:
Solved: The following system error occurred: Type mismatch... - Microsoft Fabric Community
If still facing difficulty in resolving the issue, please feel free to reachout.
If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Regards,
Pallavi.