Odbc Error when refreshing

[S_M]

Hi everyone,

I have started getting the following error since last night, as a result of which none of my odbc tables will refresh :

DataSource.Error: ODBC: ERROR [08S01] [MYSQL][ODBC 5.3(w) Driver]

Lost conection to MySQL server at 'waiting for initial communication packet', system error: 10060

Would anyone know what this is related to or how i can fix it ?

Thanks!

[S_M · Accepted solution]

Hi @v-qiuyu-msft,

After a few days of testing, we have found that these have been network issues for within the office - we have some serious IP issues ongoing and as a result, switching the datasource did not help. I even created a new pbix file to use MYSQL database but refresh did not go through, whereas at home, i was able to run it without a hitch. 

I have now resolved this by actually switching out from a desktop to a windows server on aws, and a couple of days in and the refresh runs well and takes less one third the time is used to - barring some import errors while publishing which persisted last night, i think this solution is working well 🙂