Forum Discussion
Problem with Left outer join when to create the relationship between tables
Hi aktripathi2506,
Based on my test, when you retrieve data from those three tables, then you can merge Table A with Table B use Left Outer join, it will return all of the checked column values from the Table A and matched records from the Table C. If there is no matched records in Table C, it will display as NULL in the merged table A. After apply this merge step, we can also build relationship between Table A and Table B. Please check attached .PBIX file.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
ank you v-qiuyu-msft.
I first merged two tables and then I tried creating the relation but it gives me error: one column should have unique value.
When I export the data in excel and check there is no duplicate row in both the table , I dont know why it is still saying that after merging the queries.
Now what I am thinking is: rather than creating any relation I am merging all three table.
Inner join table A and Table B and then I will do the left out join of this result with the table C.
but this process is very slow...it is taking a lot of time as my data is in millions of rows...is there a way to fasten the process? like by writing code in M rather than simiply merging by UI option.. or any thing else?