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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.