Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
21 | |
17 | |
15 | |
11 |
User | Count |
---|---|
41 | |
25 | |
22 | |
18 | |
10 |