Data refresh not working;

[RSGhelp]

Dear all,

Processing error:

[Unable to combine data] Section1/MyTable/Changed Type references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

My refresh in power bi service does not work due to this error.  

The only other query I can think of that this query references is query that retrieves a SessionID from an endpoint. This SessionID is saved and referenced in the above query (the one returning the error) :

let

Source2 = Xml.Tables(Web.Contents(""& URL_Process &""
,[Content=Text.ToBinary("
<soapenv:Envelope xmlns:soapenv="&Character.FromNumber(34)&"http://schemas.xmlsoap.org/soap/envelope/"&Character.FromNumber(34)&" xmlns:twin="&Character.FromNumber(34)&"http://www.twinfield.com/"&Character.FromNumber(34)&">
<soapenv:Header>
<twin:Header>
<twin:SessionID>"& Text.From(List.First(aKweerie)) &"</twin:SessionID>
</twin:Header>
</soapenv:Header>
<soapenv:Body>

etc.

"& Text.From(List.First(aKweerie)) &" is the sessionID i need to retrieve te data. Anyone know of a solution?

All my privacy settings are set to "None" and the report refreshes in Power BI Desktop just fine

[GilbertQ]

Hi there

The way to solve this is you will need to take the steps from your other table and put it all into a single table without referencing the other table.

[RSGhelp]

How can I generate something to put between the <twin:sessionID> ?

The SessionID query table code looks like this:

let

Source = Xml.Document(Web.Contents(""& URL_Logon &""

,[Content=Text.ToBinary("
<soap:Envelope xmlns:soap="&Character.FromNumber(34)&"http://schemas.xmlsoap.org/soap/envelope/"&Character.FromNumber(34)&" xmlns:xsi="&Character.FromNumber(34)&"http://www.w3.org/2001/XmlSchema-instance"&Character.FromNumber(34)&" xmlns:xsd="&Character.FromNumber(34)&"http://www.w3.org/2001/XmlSchema"&Character.FromNumber(34)&">

<soap:Body>


<Logon xmlns="&Character.FromNumber(34)&"http://www.twinfield.com/"&Character.FromNumber(34)&">
<user>"& User &"</user>
<password>"& Password &"</password>
<organisation>"& Organisation &"</organisation>
</Logon>
</soap:Body>
</soap:Envelope>

"),Headers=[#"Content-Type"="text/xml;charset=UTF-8"]])),
Value = Source{0}[Value],
Value1 = Value{0}[Value],
Value2 = Value1{0}[Value],
#"Filtered Rows" = Table.SelectRows(Value2, each ([Name] = "SessionID")),
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Value"}),
Value3 = #"Removed Other Columns"[Value]
in
Value3