Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |