Power BI Connector for Azure Cosmos DB

Build 24.0.9060

Fine-Tuning Data Access

Fine Tuning Data Access

You can use the following properties to gain greater control over Azure Cosmos DB API features and the strategies the connector uses to surface them:

  • RowScanDepth: This property determines the number of rows that will be scanned to detect column data types when generating table metadata.
  • TypeDetectionScheme: This property allows more control over the strategy implemented by the RowScanDepth property.
  • GenerateSchemaFiles: This property enables you to persist table metadata in static schema files that are easy to customize, to persist your changes to column data types, for example.
    You can set this property to "OnStart" to generate schema files for all tables in your database at connection. Or, you can generate schemas as you execute SELECT queries to tables.
    The resulting schemas are based on the connection properties you use to configure Automatic Schema Discovery
    To use the resulting schema files, set the Location property to the folder containing the schemas.

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