Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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 🙂