MySQL Non Negative Error

[Anonymous]

Hi all

I am trying to import MySQL into my PowerBi document and get the following error:

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] An error happened while reading data from the provider: 'Non-negative number required. Parameter name: count'. '.

This is a fresh document with just this imported, the parameter count isn't found within my database.

New to PBI so apologies if more information is needed.

Thank you.

[amitchandak]

@Anonymous , check some of the columns which have been detected as numeric might have space.

See the similar problem in past -https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-DataSource-Error-MySQL-Fatal-error/td-...

[Anonymous]

Hi, I don't have a field or table column called 'count' so I cam't see where this is?

[v-lionel-msft]

Hi @Anonymous ,

Try to refer to the case.

Non-negative number required error while appending tables 

Best regards,
Lionel Chen

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