OLE DB or ODBC Error: Fatal Error Encountered During Data Read in Power BI

Hi AustinBazaar 

Screenshot is not visible.
I am thinking this might be because of timeout issue , when PowerBI try connecting to database.
SET net_read_timeout = 99999;
SET net_write_timeout = 99999;

Run these once oon Mysql server and try connecting

On PowerBI try these :

• Clear cached permissions:
  • Go to File > Options and Settings > Data Source Settings.
  • Remove existing credentials for the MySQL source.
  • Reconnect and re-enter credentials
• Clear data load cache:
  • Navigate to File > Options > Data Load > Clear Cache.

Ensure that you are using the latest version of Power BI Desktop, as updates often fix compatibility issues

try wwitch from Direct Query mode to Import mode in Power BI if possible, as Import mode is less sensitive to connection interruptions ( for testing)

Please keep us posted if these are helpful.


Thanks