Power Query provides a set of advanced options that you can add to your query if needed.Ĭonnection string (non-credential properties) In the Navigator, select the database information you want, and then select Transform data to continue transforming the data in Power Query Editor. If needed, select an on-premises data gateway in Data gateway.Ĭhoose the authentication kind you'll use to sign in, and then enter your credentials. In this example, the connection string is dsn=SQL Server Database. 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. #Odbc excel connection for filemaker password#Database: Select this authentication type to use a username and password to access a data source with an ODBC driver. #Odbc excel connection for filemaker windows#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 are 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 was selected. 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:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |