![]() If a DSN is specified in the ODBC connection string, the attributes after the DSN specification aren't included. ![]() Known issues and limitations Connection string attributes This option isn't applicable when using a native SQL statement. Select Detect to find supported row reduction clauses, or select from one of the drop-down options (TOP, LIMIT and OFFSET, LIMIT, or ANSI SQL-compatible). Ask your vendor for more information, or go to Import data from a database using native database query.Įnables folding support for Table.FirstN. Provides a SQL statement, depending on the capabilities of the driver. Consult your ODBC driver provider for more information about valid connection strings. Keys for connection strings vary between different ODBC drivers. To escape special characters, use characters. For example, the following connection strings are valid: dsn= or driver= port= server= database=. If Data source name (DSN) is set to (None), you can enter a connection string here instead. Provides an optional connection string that can be used instead of the Data source name (DSN) selection in Power BI Desktop. ![]() 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 to sign in, and then enter your credentials. In the following 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. Database: Select this authentication type to use a username and password to access a data source with an ODBC driver. ![]()
0 Comments
Leave a Reply. |