Datasource error - unable to convert

[Anonymous]

DataSource.Error: ODBC: ERROR [HY000] [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.12 mongosqld v2.3.1]column 'Table1.Column1': unable to convert '0.00' (string) to float64

This is just one of the Errors I get when connecting to my Mongo Atlas DB, others have similar nature. The ODBC connection is working fine, since other tables from the same source come in successfully.

How would it be possible to feed the data to Power BI, since I cannot easily change the info in the database itself?

Also, since there is a column that makes a problem in the file "Table1", can I remove the column "Column1" just so the rest of the Table1 would be imported? 

Names of the Table/column was changed by me to make it more understandable.

Any thoughts?

[Anonymous]

@Anonymous,

Do you get the above error after importing data from your source into Power BI Desktop? If so, go to Query Editor of Power BI Desktop, check if there is a "Changed Type" under APPLIED STEPS. Delete this step if it exists.


In addition, if you don't want to reserve the Column1, you can write SQL statement to get required columns during the connection process.



Regards,
Lydia

[Anonymous · Accepted solution]

Hello, Lydia!

Thank you for your quick answer. As the "Changed Type" steps were not available under APPLIED STEPS, the solution I managed to come to was to reach out to the database manager and have him change the necessary columns from "string" to "integer".

As he explained, it is bad business having any of the columns go to "string" format like this anyway, so we were able to fix it and got my import up and running.

It is weird though, that Power BI doesn't import the rest of the table and just leave these fields to errors. Really defeats the purpose since the problematic columns might not be necessary anyway.

Cheers