Forum Discussion

vilenm's avatar
vilenm
Helper II
4 years ago

Encryption support error when attempting to connect to db2 source

Hi

 

What are the ways I can overcome the below error when attempting to connect to IBM db2 source from pbi desktop?

Need Help

1 Reply

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi vilenm ,

     

    This is by design. The documentation mentions that:

     

    Connect to an IBM Db2 database from Power Query Desktop :

    By default, Power Query attempts to connect to the IBM Db2 database using an encrypted connection. If Power Query can't connect using an encrypted connection, an "unable to connect" dialog box will appear. To connect using an unencrypted connection, select OK.

     

    And you can also select File -> Options and settings -> Data source settings -> Edit Permissions, then use the unencrypted connections.

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.