Forum Discussion
PC crashes when doing a left join
Ahh okay Merging is not joining. now I understand and for sure its a size issue that you are facing.
The datasource are PowerBI Dataflows in a premium environment. And i have a pro license.
Yeah . . . i already skimmed as much as i could, this crashing is also the reason i am only trying left join 1 columnn instead of 8 (which is the bare minimum i need).
Ill try exporting the dataflows to 2 csv files and see i if can join them that way. If that would work, it should point to an issue within the DataFlow itsself, no?
Sorry I didn't get your scenario! You have 2 dataflows, you call these dataflows to your Desktop and you pick different entities from these 2 Dataflows. In your model you try to join (relationship) 2 entities from those 2 dataflows and your system crashes?
Is this your issue?
I do the left join from PowerQuery, not from DAX relationmanager if that's what you mean.
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.