Forum Discussion
Data refresh not working;
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
2 Replies
- 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.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
