Forum Discussion
Rows missing after appending
Hej,
So I have two tables, both are general ledgers from business central. first table is containing data from 2016
second table has data from 2018
However after appending the tables in PowerQuery, data (rows) from first table are being missing, basically data with dates earlier than 2018.
Date source: Business Central on prem.
Connection Type: Odata feed Import
Tables size: First table around >2GB .. its not best practice to do an import i know
Second table am not sure about
Any suggestion, or is there away around that?
6 Replies
Hi Anonymous ,
Have you tried changing the order of the tables when appending? Instead of 2018 append to 2016, try 2016 append to 2018 and check if the missing dates are there. It is possible that although the date columns look the same, they are actually not as M is case sensitive. "Date" is different from "date" so Power BI created two date columns after the append.
Have you also tried applying the changes/importing the data to your model and inspect it in data view? It could be that the missing rows are just not visible in Power Query but they're still there.
...Or perhaps you have a step that removes the missing rows. If this happend to me, I would normally filter a table to show just the missing rows somewhere at the beginning of my query and then check on the steps one by one. If suddenly they were missing from the view, then that step needed to be modified.
