Dataflows - Append - Best way to append multiple tables

[RSebastiani74]

I have been trying to append four tables that come from different sources (SQL Servers) with the same schema.  I am successfully loading them but when i try to append them, it is failing no matter the tables I used.  I have tried two (smallest tables) and still failing.  I am using dataflows to ingest the data and its successful everytime but when i try to append then it fails.  How is everyone accomplishing this task?  I am doing everything within Power BI Power Query.   I am new to using Fabric and I am not sure what other options I have to do this.  When I try to append by naming the output table the same it works but then the second time around I do this I want to clear the table and start over again and not append the second set to the first one.  Any guidance is much appreciated.  Thank you.

[Royel]

@RSebastiani74 Appending tables should be straightforward and it is same as power query in power bi desktop, however there could be several reasons why you're experiencing problems. Here are few things you could consider while appending queries 

• Make sure that the data types and column names in all the tables are same. 
• You can maintain the data load order and append queries order are same, sometimes different order makes error.
•  Do not apply complex tranformation before appending queries, its a good idea to find error. 
• In this case if you apply Query Folding desable this, working with different source query folding makes error. 
• If you are using pro licence, After appending queries, un-check Enable Load for the others queries. 
• When it fails, you will get the error message, review the error message or share it with community. 

Hope, after maintaining this guideline you can overcome the error. 

Regards
Royel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RSebastiani74]

Thank you, i have done all that and still getting the same error every time.  As you can see it loads all different tables successfully and when it appends it fails every time.  See error below.

[Royel]

Its sql server error. I find a solution thread for you.

You can check is there any error on server side or not. Possible solution is just a server restart could solve the problem. 

[RSebastiani74]

I am currently trying to output to a lakehouse within the power bi environment.