In the ODBC page, enter your ODBC connection string. In the 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 an ODBC data source from Power Query Online More information: Authentication with a data source Optionally, include any connection string properties you need.

Database: Select this authentication type to use a username and password to access a data source with an ODBC driver.

Windows: Select this authentication type if you want to connect using Windows authentication.

Or, if you need to include credentials as connection string properties.

Default or Custom: Select this authentication type when you don't specify any credentials if you're using DSN configured with a username and password.

If this is the first time you're connecting to this database, select the authentication type and input your credentials when prompted. More information: Connect using advanced options You can also choose Advanced options to enter more optional connection information. In this example, a DSN name of SQL Server Database is used. In From ODBC, select the data source name (DSN) from the Data source name (DSN) drop-down box. Select the ODBC option in the Get Data selection. To make the connection, take the following steps:

Connection string (non-credential properties)Ĭonnect to an ODBC data source from Power Query Desktop.

The exact process here depends on the driver. Prerequisitesīefore you get started, make sure you've properly configured the connection in the Windows ODBC Data Source Administrator. Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.

Power query mac excel 2019