[DataSource.Error] Microsoft SQL: Error converting data type nvarchar to nume

[Chipsnump]

Hi,

I've tried several times to connect to SQL, but everytimes try to close & apply the power query it shows the errror like this:

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Error converting data type nvarchar to numeric.. '.

how could we solve this issue?

[tharunkumarRTK]

@Chipsnump 

I think the column data types are not accurate. To find the errors you can multi select all the columns in power query and click on keep errors on the top ribbon then you will be able to find the values which are causing this issue. Choose the correct data types for each column and try again.

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