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
danextian's avatar
danextian
Super User
6 years ago

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Hi,


    Many thanks for your answer.

    Yes I tried changing the order of the tables by changing the primary table and tried both tables to be primary. I also made sure that columns names and order were identical. Still same problem 😕
    • danextian's avatar
      danextian
      Super User
      6 years ago

      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. 

      • 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