Forum Discussion
Data loss while Importing powerBi data to excel
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
I am able to get the right #$ of rows in powerbi (1070), my concern right now is how do i move this data in excel withous losing it? When I copy the entire table right now to excel it only copies 1000 rows not 1070...please help
s12saxen，
Right click the merged table in Data view and select "Copy Table", then use "Ctrl+V" to paste the data of the table to Excel, I get all 1246 rows with this method.
Regards,
Lydias12saxen,
Do you use December update of Power BI Desktop? Please clear cache in your Power BI Desktop, reboot machine and check if you get all rows.
Regards,
Lydia