Forum Discussion
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...
dgbraqe, This issue should be now be fixed. Please download the Power BI Desktop July release and let us know if things are now working as expected.
Ehren
Hello Ehren!
I ran the tests using sorting in the SQL command and it worked correctly.
Just one more question, I have some queries that I do not use the SQL command, I directly use the view / table in the database. In this case, how can I keep the data sorted?
I am happy to have helped you, and thank you for your commitment and dedication to solving this problem. Please let us know when the correction is available.
Hi,
Could you please tell what you have done to have this worked? Did you do the sort in SQL or in PowerBi?