Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

MySQL Connection Error

Hi,

I am getting the following error while trying to load data in Power BI Desktop

I have never faced this issue earlier. After facing this issue today, I dowloanded the connectore using the following link (https://dev.mysql.com/downloads/connector/net/) and have installed it. But, nothing seems to be soliving the issue. Can someone please help?
Thank you

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    HI Anonymous,

    This issue seems more related to the data drivers. What version of data driver are you worked on? 32bit or 64bit? Have you instead the match version with the remote data source settings?

    Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks for responding @Xiaoxin Sheng
      I am using 64bit data driver. The tables are in Heidi SQL. I had rreviously connected to the tables in Power Query. But, in the recent times though I can access the Heidi SQL but I cannot access the same data from Power Query. Getting the error

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Anonymous,

        What version of power bi desktop client are you worked? Have you tried to test current connection on the last version power bi desktop?

        Regards,

        Xiaoxin Sheng