Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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-p/512516
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |