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...
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.
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.
I am currently trying to output to a lakehouse within the power bi environment.