Refresh error

[anoomohan]

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

[tharunkumarRTK · Accepted 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

[v-jiewu-msft · Accepted solution]

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.

[anoomohan]

Thanks all, its ok now. there was a formula in one row, which i removed from excel. 

[v-jiewu-msft · Accepted solution]

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.

[SaiTejaTalasila]

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 

[SaiTejaTalasila · Accepted solution]

Hi @anoomohan ,

Try the steps whatever I have mentioned you will be able find it.

Thanks,

Sai Teja 

[tharunkumarRTK · Accepted 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