Power BI Connector for Excel Services

Build 20.0.7587

Type Detection Scheme

Determines how to determine the data type of columns.

Data Type

string

Default Value

"RowScan"

Remarks

NoneSetting TypeDetectionScheme to None will return all columns as the string type.
RowScanSetting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587