cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jjuurikas Frequent Visitor
Frequent Visitor

Datasource error - unable to convert

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
jjuurikas Frequent Visitor
Frequent Visitor

Re: Datasource error - unable to convert

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

2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: Datasource error - unable to convert

@jjuurikas,

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.
2.JPG

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

1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jjuurikas Frequent Visitor
Frequent Visitor

Re: Datasource error - unable to convert

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 35 members 1,105 guests
Please welcome our newest community members: