Error: The following system error occurred: Type mismatch. Table:

[henriqueluiz]

Guys,

I'm trying to solve this issue, but without success. I can't find the column that shows the error in the field.

The following system error occurred: Type mismatch. Table: SBZ FE Inventory.

When I manually update on the desktop, it works, it doesn't show any error, so I always have to publish.

Can you help me find what this error could be? I've already changed the date fields too and nothing!

Cheers

[v-pagayam-msft]

Hi @henriqueluiz ,
I wanted to check and see if you had a chance to review my previous message or Please let me know if everything is sorted.If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.


Thank you for your cooperation. Have a great day.

[v-pagayam-msft]

Hi @henriqueluiz ,

We haven't heard back from you regarding our last response and wanted to check if your issue has been resolved. If our response addressed your query, please mark it as Accept as Solution and click Yes if you found it helpful.If you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @henriqueluiz ,
I just wanted to kindly follow up to see if you had a chance to review the previous response provided by us. I hope it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.Still required any further assistance, feel free to reachout.

Thank you for being a valued member of Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @henriqueluiz ,
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.

[pallavi_r · Accepted solution]

Hi @henriqueluiz ,

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