.Unable to combine data

ImkeF AlexisOlson miguel507 

TLDR: I keep on getting the following error when I am trying to refresh a dataset (semantic model) in service. How do I debug this?

Data source error: [Unable to combine data] [Unable to combine data] Section1/childrenDim/src44 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.. The exception was raised by the IDbCommand interface. Table: childrenDim.

childrenDim table is created as following like this. I am querying server1 tbl to get the EmpID and reducing the distinct IDs with Accumulate to be passesd on dynamically to sql statement to query server2 table to get additional details.

//children table
let
    Source = Sql.Database("Azure_SQL_SERVER1", "production_db", [Query="// some query that returns a two coulmn table as following"])
in
    Source

| EmployeeID 	| OwnerID 	|
|------------	|---------	|
| 123        	| 789     	|
| 456        	| 987     	|

//childrenDim table

let
    src0 = ()=> Children,
    src00 = src0(),
    src1 = ()=> src00[EmployeeID],
    src11 = src1(),
    src2 = ()=> List.Distinct(src11),
    src22 = src2(),
    // array {123,456} reduced to generate a string (123,456) to be passed on 
   // to sql later
    src3 = ()=> Text.Replace("("&List.Accumulate(src22,"",(state,current)=>Text.From(state)&","&Text.From(current))&")","(,","("),
    src33 = src3(),
    src4 = let a = Sql.Database("Azure_SQL_SERVER2", "production_db", [CommandTimeout = #duration(0, 1, 0, 0)])
in  Value.NativeQuery(a,"
  select TRY_CONVERT(bigint,Emp_ID) as EmpID,First_Name+' '+Last_name as Name
FROM schema.[Dim_Emp]
where TRY_CONVERT(INT, Emp_ID) IN"&src33&"",null,[PreserveTypes = true, EnableFolding = true])
 //src44 = src4()
in
    src4

// the above returns this
| EmpID 	| Name  	|
|-------	|-------	|
| 123   	| lorem 	|
| 456   	| ipsum 	|

This fails in service but locally it has no issue. I need to work in service , how do I get past this error.

 Thank you in advance.