Power BI Connector for Google Sheets

Build 24.0.9060

TypeDetectionScheme

Determines how to determine the data types of columns.

Possible Values

None, RowScan

Data Type

string

Default Value

"RowScan"

Remarks

NoneSetting TypeDetectionScheme to None returns all columns as the string type. Note: Even when set to None, the column names are still scanned when Header is set to True.
RowScanSetting TypeDetectionScheme to RowScan scans rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned. Setting this to -1 directs the driver to scan the entire sheet.

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