The CData Power BI Connector for REST enables the granular control useful in more complex deployments or network topologies; you can use the following connection properties to fine-tune data access, connect through a firewall, or troubleshoot connections.

Fine-Tuning Data Access

You can use the following properties to gain greater control over how the connector parses the XML data into rows. You can also customize the schemas detected based on the connection string.

• RowScanDepth: This property determines the number of rows that will be scanned to detect column data types when generating table metadata.
• XPath: Explicitly specify the paths to nested object arrays, instead of detecting them during the row scan.

• 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. Set this property to "OnStart" to generate schema files for all tables in your database at connection. Or, set this property to "OnUse" to 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. See Customizing Schemas for more information.