Forum Discussion
OLE DB or ODBC error: [DataSource.Error] MySQL: Fatal error encountered during data read.
Hello Anonymous,
I'd say there was an error on one of the steps, perhaps it wasnt shown on the query editor, (you'd need to refresh in every single step), and there's also the possibility that some data that wasnt being loaded in the query editor was causing the error (i.e, a # when a numeric value is expected, i've suffered a couple of times by replacing # by empty spaces after setting the data type to numeric, even tough it might work in the query editor, when the full data set is loaded it will give an error)
Hello,
Have you checked all the steps in the query editor in case any of them gives an error? (You might have to do a refresh on the query editor)
I have done the refresh and checked the query editor and everythings seems fine in query editor with no error return.
I managed to get rid of this error message by redoing the query steps, one by one. After completing one step then i click on close and apply and save after the applying steps succeed and repeat for second steps.
Anyway, i would like to know the root cause of it so that i can prevent it in future.
Hello Anonymous,
I'd say there was an error on one of the steps, perhaps it wasnt shown on the query editor, (you'd need to refresh in every single step), and there's also the possibility that some data that wasnt being loaded in the query editor was causing the error (i.e, a # when a numeric value is expected, i've suffered a couple of times by replacing # by empty spaces after setting the data type to numeric, even tough it might work in the query editor, when the full data set is loaded it will give an error)
it is not true, when i refresh single table which give error on main refresh, error does not appears
Hello.
You redo the query steps in the power query editor in powerbi?
Im kind of new in this and im trying to stablish a connection to mysql.
I´ll be waiting for an answer.
Best Regards
