Encryption support error when attempting to connect to db2 source

[vilenm]

Hi

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

[v-kkf-msft]

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.