MySQL Input string was not in a correct format

[Anonymous]

I'm linking Power BI Desktop to a MySQL database (10 tables), and when I refresh the first time, I get: "An error happened while reading data from the provider: 'Input string was not in a correct format.'"

When I refresh the second time I get: "OLE DB or ODBC error: [DataSource.Error] An error happened while reading data from the provider: 'Input string was not in a correct format.'."

When I refresh a third time, it loads all the tables just fine, and successfully completes.

Is Bill Gates sitting at a terminal, counting how many times I try to load, and saying "three's a charm"?

I don't think any of my strings are in the wrong format, but even if they were, I would expect the software to continually fail, rather than to let me in eventually.

What's going on here?

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .