Unable to view Errors

[Anonymous]

Hi there,

Having clicked on "Apply"  I am nolonger getting the option to "view errors".  it is just stating this:

Population-country-1950-1999

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number.. The current operation was cancelled because another operation in the transaction failed. '.

Can Anyone help?

[Icey · Accepted solution]

Hi @Anonymous ,

Is this problem sloved?

If it is sloved, could you kindly accept it as a solution to close this case?  

If not, please let me know.  

Best Regards

Icey

[Icey]

Hi @Anonymous ,

In your scenarios, the error is caused by the data format. You can refer to these posts:

1. https://community.powerbi.com/t5/Desktop/Error-DataFormat-Error-We-couldn-t-convert-to-Number-Details/td-p/150869

2. https://community.powerbi.com/t5/Desktop/Error-returned-OLE-DB-or-ODBC-error-DataFormat-Error-We-couldnt/td-p/486357

3. https://community.powerbi.com/t5/Desktop/DataFormat-error-We-couldnt-convert-to-Number/td-p/61492

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.