Forum Discussion
Solved
PC crashes when doing a left join
Gday all! This week i've been having an issue with a powerquery left join. I have 2 tables, table 1 contains an id that corresponds with a unique id in table 2. Now i want to join just 1 column...
Ahh okay Merging is not joining. now I understand and for sure its a size issue that you are facing.
Sorry but why using PowerQuery for joining? Power Query is good for ETL (Extraction, transformation and loading). Modeling(joins and relationships) is done in power bi desktop and DAX.
Maybe we're not understanding. I geuss a better translation would be 'merging'?
The reason i'm doing it in Powerquery is so that i don't have to load the table that contains more data than i need to the model. But i need it to create a unique id so can i can make a relationship to another table.
Ahh okay Merging is not joining. now I understand and for sure its a size issue that you are facing.