Power BI Connector for xBase

Build 24.0.9060

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
DirectQueryLimitLimits the number of rows when using the DirectQuery mode. This helps avoid performance issues at design time.
EmptyStringIsNullTells provider to expose empty strings as null values.
EnableForeignKeyDetectionWhether to detect the foreign keys in ODBC.
ExcludeFileExtensionsSet to true if file extensions should be excluded from table names.
MaximumColumnSizeThe maximum column size.
MaxRowsLimits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
OtherThese hidden properties are used only in specific use cases.
PseudoColumnsSpecify a set of pseudocolumns to expose as columns.
RTKThe runtime key used for licensing.
SetExactOnMimics beahviour of SET EXACT ON mode in Microsoft OLE DB provider.
UserDefinedViewsA filepath pointing to the JSON configuration file containing your custom views.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060