Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Issue connecting to MySQL db through PowerQuery

  1. #1
    Board Regular
    Join Date
    Oct 2014
    Location
    Toronto, Canada
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Issue connecting to MySQL db through PowerQuery


    Issue connecting to MySQL db through PowerQuery
    Ladies and Gents,

    I've come across an extremely puzzling issue. I'm attempting to connect to a MySQL db through PowerQuery. I downloaded the mysql connector (originally version 6.6.5 but rolled back to 6.4.6 in an attempt to resolve this issue) and connected to the db. So far so good. It asks me to turn off encrypted connections, no problem. I can preview every single table in the db except for one. I can load all of those and build queries around them, but there is ONE table which I can't view and, FML, it is the ONLY one I need .

    The error I get in the Navigation window (when we load the db and want to select tables) is as follows:

    Permission Error: The MySql source doesn't support encrypted connections. Please check your security policy and try connecting without encryption through the Data Source Settings dialog to continue. (Source at [192.xxx.xxx.xxx;dbname].)
    When I hit edit, what I see is:

    Try changing the Connection encryption setting to connect to this data source.
    I've made sure encryption is off by going to File-->Options and Settings-->Data Source Settings

    There is also a "Edit Credentials" link in the PQ window which I've clicked. It just asks me for the credentials again. When I hit Connect, I get a dialog:

    The data source you're trying to access doesn't support encryption. To access this data source using an unencrypted connection, click OK.
    Hitting ok just brings the same dialog again in an endless loop.

    I was hoping the fine brains here would be able to make sense of this.

    Many thanks in advance,
    Ben

  2. #2
    Board Regular
    Join Date
    Oct 2014
    Location
    Toronto, Canada
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Issue connecting to MySQL db through PowerQuery

    Alright, so I figured out the issue through some back and forth with my db admin. Turns out, there is a text field which was encoded as UTF-16 which was causing the issue. Changing the encoding to UTF-8 resolved the issue.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •