Forum Discussion
Dataflows - Append - Best way to append multiple tables
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 th...
Royel
Super User
Super UserRSebastiani74 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.
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.