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)
<pre id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Tradução"><span class="Y2IQFc" lang="en">Each case is different,
it always happens to me,
my solution is,
Log out of all Microsoft accounts including Power Bi and log in again.
Sometimes we remain logged in with our personal account and business account on Microsoft and there may be a conflict</span></pre>
This is an interesting angle. Maybe MS support people can comment.