ODBC Driver for Microsoft Power BI XMLA

Build 25.0.9434

Schema

This section provides a complete list of the Schema properties you can configure in the connection settings for this provider.


PropertyDescription
LocationSpecifies the location of a directory containing schema files that define tables, views, and stored procedures. Depending on your service's requirements, this may be expressed as either an absolute path or a relative path.
BrowsableSchemasOptional setting that restricts the schemas reported to a subset of all available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC .
TablesOptional setting that restricts the tables reported to a subset of all available tables. For example, Tables=TableA,TableB,TableC .
ViewsOptional setting that restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC .
CatalogSpecifies the Power BI workspace and dataset to use, combined into a single catalog name. For example, MyWorkspace_MyDataset. Leave this blank to search across all available workspaces and datasets.
IncludeJoinColumnsEnable this property to add extra join columns to each table. These columns reference foreign keys for use in ON conditions when performing joins.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434