Forum Discussion
Data loss while Importing powerBi data to excel
Hi, I have two excel files (File1 and File20. File1 has 1070 rows, and file2 has about 11000 rows. I moved them to powerbi and merged them (Outer left, so all rows from file1 should be there and onl...
s12saxen，
Have you tested the above simple query? When you don't extract value from Table2 column in the merged table, the row number of the merged table is same as the row number of first table. When you extract values, the merged table return more rows because the relationship of column1 fields between two tables is 1:many.
In your scenario, 1070 rows are contained in the 1246 rows, as the relationship of join fields between the two tables is 1: many, you get 1246 rows when you extract values in the merged table.
Regards,
Lydia
How do I get only the 1070 rows from table1, with all matching fields only from table2? I thought thats what left outer join does? I also want to be able to get this data in excel