Forum Discussion
Append data from different source fails in service
Your service error is caused by
Timeout was reached
so you need to address that separately.
To prevent tables from loading multiple times you can disable load for upstream tables that you don't need in your report, and/or use the Table.Buffer function to enforce spooling before the merge.
Thank lbendlin.
The timeout issue only occurs when I am appending the data. When I load it in a single table, it works well without any issue.
My assumption on append is that it loads the data once the individual tables are loaded from the source system. What I am guessing it, append it also trying to hit the source system to get the data. is that correct?
Yes, hence my proposal to use Table.Buffer
Sorry, I didn't get that. Can you elaborate, please? What changes I am supposed to do here?