Forum Discussion

S_M's avatar
S_M
Helper III
9 years ago
Solved

Odbc Error when refreshing

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...
Need Help
  • S_M's avatar
    S_M
    9 years ago

    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 :)   

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi S_M,

     

    Both personal gateway and data gateway are available for pro user. In your scenario, if you publish the report to Power BI Service, you need to configure gateway like mentioned above. As both ODBC and MySQL are not in cloud, while the Power BI Service is in the cloud, it requires gateway to communicate each other. If you only refresh report in desktop, gateway is not required.

     

    Best Regards,

    Qiuyun Yu

arify's avatar
arify
Microsoft Employee
9 years ago

Hi,

 

  1. Do you get this error consistently? Have you tried refreshing, and made sure the MySQL server is running?
  2. Have you tried using the built-in MySQL connector instead of ODBC?

Thanks

  • S_M's avatar
    S_M
    Helper III
    9 years ago
    Hi!

    Thanks for your response

    I have had no troubles at all until last night when something went amiss - since then this error shoots consistently, usually when running a refresh all. Sometimes i am able to refresh individual tables, most times they fail and give the above result. It has been incredibly frustrating as i dont quite understand what the problem may be : MySQL is running, i am able to connect to the ODBC using tools like HeidiSQL, i am able to even import tables from the ODBC, but on refreshing it, it gives an error.

    I am not sure if i can migrate my existing data model to the MySQL connectors without breaking my model. I am fairly certain there is no problem with the firewall and i am completely lost on how to resolve this issue, having spent the past day eliminating the possible reasons