Append data from different source fails in service

[Anonymous]

Hi Experts, 

I have a weird issue. I am appending the data from 2 different sources.

1 is an on-prem oracle source for which I have a  gateway

2 Snowflake - Native Query

I am importing the data with the import method and then using append as a new query to create an appended new table. 

When I click refresh in the Power BI Desktop, I can see data is being loaded in both the tables however I see the data is getting loaded in the appended table before both the tables are completely loaded. 

3rd table in the above image is the appended table. Which gets loaded even before the 1st table and 2nd Table

In the end, data gets loaded in both that table and report works fine However when I publish this report to the Power BI Service and hit refresh after setting up all the gateway and credentials, it fails with the below error:

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":"ODBC: ERROR [HY000] [Microsoft][Snowflake] (4) \n REST request for URL https://XXX-souXXXst-2.snowflakecomputing.com:443/session/v1/login-request?requestId=XXXX-b270-428d-XXXXb-26XXX51492d5&request_guid=9XXXX82&warehouse=CUXXX_WH failed: CURLerror (curl_easy_perform() failed) - code=28 msg='Timeout was reached' osCode=10060 osMsg='Unknown error'.\n "}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Snowflake"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"XXX-souXXXst-2.snowflakecomputing.com;CUXXX_WH"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, 
{})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Hardship_Debtsale.

Any idea what is wrong here. It looks like the individual table and the appended table is firing the query at the same time. 

Hardship_debtsale is my appended table.

[lbendlin]

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.

[Anonymous]

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?

[lbendlin]

Yes, hence my proposal to use Table.Buffer

[Anonymous]

Sorry, I didn't get that. Can you elaborate, please? What changes I am supposed to do here? 

[lbendlin]

Table.Buffer - PowerQuery M | Microsoft Docs