Forum Discussion
Rows missing after appending
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.
Hi,
I double checked your suggestions. There is litterally no filters anywhere.
In fact the data are missing after being appended, in both power query and in modelling. The funny part that I cant understand is, if I use a union(TableA, TableB) in dax in modelling. The tabels will be appended with no issues.
However, this is not what Iam looking for, as my plan was to disable load for the both tables and then keep loading the appended table.
Appending them using dax, will require loading both plus having the third table ( the appended table in DAX). Not sure if that will consume extra space, and if that considered to be a bad approach?
Best
Anonymous
You may take a look at the post below.
https://community.powerbi.com/t5/Power-Query/Append-table-lost-rows/m-p/437138#M17708
Hi,
Many thanks for your answer. If I understand well, the solution is to do some kind of sort in SQL. Did I understand wrong? would the sort trick work in Power Bi or in SQL?
if in SQL, this is not possible in my case, as my data is coming from Business Central on Prem, using OData feed.
Any other suggestion would be appreciated 🙂
