sql query is running on database but not uploading in power bi

[Shellysethi]

The sql query is running on database but when I try to upload it on power bi, when the last 20  rows left, error message pop up
The error message is OLE DB or ODBC error: [DataSource.Error] MySQL: Fatal error encountered during data read..

How to solve this error?

[lbendlin]

Most likely you are running into the 120 second timeout on the SQL server.  Make your query run faster (through indexes etc).