Once you've selected the advanced options you require, select OK in Power Query Desktop or Next in Power Query Online to connect to your SQL Server database. If checked, when a node in the SQL Server failover group isn't available, Power Query moves from that node to another when failover occurs. If cleared, Navigator displays only the tables whose columns and rows contain data. If checked, the Navigator displays the complete hierarchy of tables in the database you're connecting to. If this box is cleared, you won’t see those columns. If checked, includes columns that might have relationships to other tables. This option is only available in Power Query Desktop.įor information, go to Import data from a database using native database query. If your connection lasts longer than 10 minutes (the default timeout), you can enter another value in minutes to keep the connection open longer. The following table lists all of the advanced options you can set in Power Query Desktop and Power Query Online. In Navigator, select the data you require, and then select Transform data.īoth Power Query Desktop and Power Query Online provide a set of advanced options that you can add to your query if needed. If the connection is not encrypted, and the connection dialog contains a Use Encrypted Connection check box, clear the check box. If this is the first time you're connecting to this database, select the authentication kind and input your credentials. If needed, select an on-premises data gateway. In Navigator, select the database information you want, then either select Load to load the data or Transform Data to continue transforming the data in Power Query Editor.Ĭonnect to SQL Server database from Power Query Online Select OK to connect to the database by using an unencrypted connection, or follow these instructions to setup encrypted connections to SQL Server. You can reuse an existing database or you can create a Microsoft SQL Server database where you can create the IBM Content Navigator configuration table after you configure and deploy the web application. If the connection is not encrypted, you'll be prompted with the following dialog. You must point to an existing database when you configure and deploy IBM Content Navigator.
If this is the first time you're connecting to this database, select the authentication type, input your credentials, and select the level to apply the authentication settings to. Select either the Import or DirectQuery data connectivity mode (Power BI Desktop only). In the SQL Server database dialog that appears, provide the name of the server and database (optional). Select the SQL Server database option in the connector selection. To make the connection, take the following steps: Capabilities SupportedĬonnect to SQL Server database from Power Query Desktop SQL Server Native Client 11.0 and SQL Server Native Client 10.0 are both supported in the latest version. However, for optimal performance, we recommend that the customer installs the SQL Server Native Client before using the SQL Server connector.
#WHAT IS SQL NAVIGATOR FOR SQL SERVER DRIVER#
Prerequisitesīy default, Power BI installs an OLE DB driver for SQL Server. Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.