Forum Discussion
Merge / Join is skipped rows
I have two tables which are merged in a dataflow and output as a new table:
- 1. table: Data is grouped here and I get the last sales date per item.
- 2nd table: This is a table with master data.
Using a join, I add the last sales date to the 2nd table and output this query as a new table.
For whatever reason - probably because there is a lot of data - individual articles are probably skipped. If I shorten the 2nd table, I get all the data.
Does anyone have any idea how I can continue to get an effective join? Is it possible to add a buffer for a few seconds?
2 Replies
Show your Power Query code and maybe provide some sample data to illustrate the issue.
Hi joshua1990
Check the result is not skip your rows, just simply did not appear in the order of your original Index
Solved: Merging Table is Skipping Rows - Microsoft Fabric Community
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
