Forum Discussion
Create relationship between with two columns
I just come up with the same problem of joining composite keys and looking around for a solution.
Sad to see that the answer is "doing some workarounds"...... :catsad:
Even the old-aged Microsoft Query is doing better on this..... I'd better go for the MS Query...... :smileylol:
Before using MS Query for joining the tables together, really give Power Query a chance. MS Query and PQ are not even from the same Universe, especially when it comes to transformation in later jobs ;)
imkc1127 its not a workaround its by design.
Schema design for data warehousing is different to that of traditional databases and is intended to keep things easy to understand for users creating reports and also faster during processing. A database schema will typically be more complicated because it will need to handle data entry and integrity.
Merging columns to form unique primary keys should just be part of the process that imports data if using a warehouse. If I'm reporting direct from a traditional db with multiple joins required I either set up views in the database to pre-process or use power query like LarsSchreiber suggests. It basically shifts the need to have a deep understanding of the database away from the end user creating reports.
