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 adapter 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 Power BI XMLA, dimensions and measures within tables are naturally related, so ON conditions are optional. The Power BI XMLA Adapter supports joins without requiring these conditions.