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. In this example, the server name and port are :4000 and the IBM Db2 database being accessed is NORTHWD2.

If you're connecting from Power BI Desktop, select either the Import or DirectQuery data connectivity mode. The rest of these example steps use the Import data connectivity mode. To learn more about DirectQuery, go to Use DirectQuery in Power BI Desktop.īy default, the IBM Db2 database dialog box uses the Microsoft driver during sign in.

More information: Connect using advanced options If you want to use the IBM driver, open Advanced options and select IBM. If you select DirectQuery as your data connectivity mode, the SQL statement in the advanced options will be disabled.

DirectQuery currently does not support query push down on top of a native database query for the IBM Db2 connector. 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. If Power Query can't connect using an encrypted connection, an 'unable to connect' dialog box will appear.įor more information about authentication, go to Authentication with a data source.īy default, Power Query attempts to connect to the IBM Db2 database using an encrypted connection. In Navigator, select the data you require, then either select Load to load the data or Transform Data to transform the data.Ĭonnect to an IBM Db2 database from Power Query Online To connect using an unencrypted connection, select OK.

Razorsql log