Are multi-column relationships not supported by design?

[SuraMan]

In Power BI Desktop data models, relationships (joins) can be specified between a single column of each table.

Multi-column joins between tables are not supported. The suggested work around has been to concatenate composite key columns into a single key and join on that. This doesn't look like an elegant solution to me.

Is this behaviour by design?

Or, are there plans to support multi-column joins in the future?

Thanks

[v-jiascu-msft]

Hi @SuraMan,

I afraid this is by design. Though you already have the workaround, you could vote an idea here: allow-compound-keys-in-relationships. This is the voice of customers, which would bring up new features for Power BI.

Best Regards!

Dale

[SuraMan]

Hi,

If this is by design, what is the reason for it?

Thanks