undefined

[Vineela__sai19]

Issue connecting mainframe db2 to pbi desktop. When we are trying to connect to the db through db tool like dbeaver it is getting connected. But when we are trying to connect to pbi it is throwing error like couldn't authenticate with the credentials provided. But the same credentials were working fine with db tool. Why it is not in pbi. Please suggest. ASAP

Thanks in advance.

[Vineela__sai19]

After this step. I'm getting "we couldn't authenticate with the credentials provided" error. But the credentials were accurate.

[v-rongtiep-msft]

Hi @Vineela__sai19 ,

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.

More details: Power Query IBM Db2 database connector - Power Query | Microsoft Learn

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vineela__sai19]

 This is the error I'm getting when trying to connect. But the credentials were accurate.

[v-rongtiep-msft]

Hi @Vineela__sai19 ,

To make the connection, take the following steps:

• Select the IBM Db2 database option from Get Data.
• Specify the IBM Db2 server to connect to in Server. If a port is required, specify it by using the format ServerName:Port, where Port is the port number. Also, enter the IBM Db2 database you want to access in Database. 
• If you're connecting from Power BI Desktop, select either the Import or DirectQuery data connectivity mode.

• If this is the first time you're connecting to this IBM Db2 database, select the authentication type you want to use, enter your credentials, and then select Connect.
• 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.

More details: Power Query IBM Db2 database connector - Power Query | Microsoft Learn

If it still does not help, please provide more error information.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.