October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Dear all,
getting below error while trying to refresh, i rechecked in the excel "each acct tgt" - but unable to find any mismatch
pls help on how to further check this?
Data source error: The following system error occurred: Type mismatch. Table: EACH ACCT TGT.
Cluster URI: WABI-NORTH-EUROPE-O-PRIMARY-redirect.analysis.windows.net
Activity ID: abbfbfeb-5ff8-4c88-a8ab-60b13a02ea73
Request ID: b7421da9-38cc-8906-134d-3f9719188b16
Time: 2024-07-14 07:59:41Z
Solved! Go to Solution.
@anoomohan
Have you verified the data types of all the columns? This type of error happens in scenarios where you have text values in a column with whole number or int data type. I would suggest you to open the PBIX file and get into power query, select all columns and then click on 'Keep Errors'. Then you will be able to find the rows which are causing this error.
Need Power BI consultation, hire me on UpWork .
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Hi @anoomohan ,
Based on the description, try to check data type in the table columns.
Besides, try to copy data from a table to another table and refresh the data.
You can also view the following documents to learn more information.
Solved: The following system error occurred: Type mismatch... - Microsoft Fabric Community
Troubleshoot refresh scenarios - Power BI | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks all, its ok now. there was a formula in one row, which i removed from excel.
Hi @anoomohan ,
Based on the description, try to check data type in the table columns.
Besides, try to copy data from a table to another table and refresh the data.
You can also view the following documents to learn more information.
Solved: The following system error occurred: Type mismatch... - Microsoft Fabric Community
Troubleshoot refresh scenarios - Power BI | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @anoomohan ,
Open transform data and go to view>turn on column profiler/column quality and in applied steps check every applied steps for errors.
I hope it will be helpful.
Thanks,
Sai Teja
@anoomohan
Have you verified the data types of all the columns? This type of error happens in scenarios where you have text values in a column with whole number or int data type. I would suggest you to open the PBIX file and get into power query, select all columns and then click on 'Keep Errors'. Then you will be able to find the rows which are causing this error.
Need Power BI consultation, hire me on UpWork .
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun