Power BI Connector for Elasticsearch

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
ClientSideEvaluationSet ClientSideEvaluation to true to perform Evaluation client side on nested objects.
DirectQueryLimitLimits the number of rows when using the DirectQuery mode. This helps avoid performance issues at design time.
EnableForeignKeyDetectionWhether to detect the foreign keys in ODBC.
GenerateSchemaFilesIndicates the user preference as to when schemas should be generated and saved.
MaximumColumnSizeThe maximum column size.
MaxResultsThe maximum number of total results to return from Elasticsearch when using the default Search API.
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.
PageSizeThe number of results to return per request from Elasticsearch.
PaginationModeSpecifies whether to use PIT with search_after or scrolls to page through query results.
PITDurationSpecifies the time unit to use for keep alive when retrieving results via PIT API.
PseudoColumnsSpecify a set of pseudocolumns to expose as columns.
QueryPassthroughThis option allows you to pass exact queries to Elasticsearch.
ReadonlyYou can use this property to enforce read-only access to Elasticsearch from the provider.
RowScanDepthThe maximum number of rows to scan when generating table metadata. Set this property to gain more control over how the provider detects arrays.
RTKThe runtime key used for licensing.
ScrollDurationSpecifies the time unit to use for keep alive when retrieving results via the Scroll API.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseFullyQualifiedNestedTableNameSet this to true to set the generated table name as the complete source path when flattening nested documents using Relational DataModel .
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