Power BI Connector for Smartsheet

Build 23.0.8839


Determines how to determine the data types of columns.

Possible Values

None, RowScan, ColumnFormat

Data Type


Default Value



NoneSetting TypeDetectionScheme to None will return all columns as the string type. Note: Even when set to None, the column names will still be scanned when Header is set to True.
RowScanSetting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned.
ColumnFormatSetting TypeDetectionScheme to ColumnFormat will report the data type based on the format of the column.

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