Forum Discussion

dgbraqe's avatar
dgbraqe
Frequent Visitor
8 years ago
Solved

Append table lost rows

Hi, I'm having a problem loading two queries from different bases and merging them using the "Append as new" option. The resulting table is joining records incorrectly, following examples:   Base 1...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, 

 

 

Could you please tell what you have done to have this worked? Did you do the sort in SQL or in PowerBi?

edhans's avatar
edhans
Community Champion
6 years ago

Anonymous This was fixed almost two years ago and it was a pretty big undertaking on the back end to rework how the Power BI service worked to avoid the issue. The Desktop app was fixed at that time as well.

 

Perhaps you could start a new thread on exactly what issue you are facing, because this one isn't the same thing. I was one of those that reported on the issue and I have a report in my tenant that was designed to find this issue and it hasn't triggered an alert in over 18 months. I should just delete it honestly, but haven't done it yet.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     

     

    Ok, many thanks for your answer. Luckily I gave the project away. So it is in fact not my problem anymore.

     

    However, Iam still looking for en explanation for why is this happening. If that is a bug or so, then it is a dangerous one!