Append does not work on PBI Service

[JimboC]

I have two tables. Table1 and Table2. Table1 loads data from a Redshift database, Table2 loads data from a spreadsheet from OneDrive and then appends table1 to it as its last step. Both tables have the same fields with the same names which have the same datatypes. This works as expected on the desktop but fails with the following message in PBI Service. If the append step is removed both tables refresh as expected on both the desktop and PIB Service. Looking for what the issue could be.

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We're sorry, an error occurred during evaluation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: Table2.
Cluster URI: WABI-US-NORTH-CENTRAL-H-PRIMARY-redirect.analysis.windows.net
Activity ID: 3ae6049a-4acf-4e75-8d06-653dc686fff5
Request ID: 4e8e1530-ba17-e923-9078-8cb800dd1e36
Time: 2023-08-24 17:21:29Z

[JimboC]

1. I had tried the Append as new. Same result, works on desktop, not on PBI Service.

2. The Redshift db is set up in our gateway. Both the database sourced data and the spreadsheet data load fine without the append. 

3. Thanks for the reply

[lbendlin]

Two things.

1. There is a difference between "Append"  and "Append as new". Try it out

2. Does your Redshift data source require a gateway ?