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 ...
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 🙂