![]() ![]() ![]() 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. If the connection is not encrypted, you'll be prompted with the following dialog. 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. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |