Enable this property to add extra join columns to each table. These columns reference foreign keys for use in ON conditions when performing joins.

Data Type

bool

Default Value

false

Remarks

Set IncludeJoinColumns to true if your tool requires ON conditions or generates them automatically based on foreign key references. When enabled, the server adds foreign key references to every table, even though these columns do not return any data. Their sole purpose is to provide references for ON conditions in join operations.

In Microsoft Power BI XMLA, dimensions and measures within tables are naturally related, so ON conditions are optional. The CData MCP Server for Microsoft Power BI XMLA supports joins without requiring these conditions.