Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
RSGhelp
Frequent Visitor

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 2
GilbertQ
Super User
Super User

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.