User Profile
Kutsysteem
New Member
Joined 2 years ago
User Widgets
Contributions
Re: Use column record in M Query / Power Query
Hi I have a simular issue. Power Bi gives this error: Formula.Firewall: Query 'Getmutaties' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. Here is my code: let Url = "https://soap.e-boekhouden.nl/soap.asmx" , SessionIDpass = Opensession{0}[Table]{0}[Table]{0}[Table]{0}[Table]{0}[SessionID], // SOAPEnvelope with correct XML-syntax and parameters SOAPEnvelope = " <soap:Envelope xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema"" xmlns:soap=""http://schemas.xmlsoap.org/soap/envelope/""> <soap:Body> <GetMutaties xmlns=""http://www.e-boekhouden.nl/soap""> <SessionID>" & SessionIDpass & "</SessionID> <SecurityCode2>xxxxxx</SecurityCode2> <cFilter> <MutatieNrVan>1</MutatieNrVan> <MutatieNrTm>1000</MutatieNrTm> <DatumVan>01/01/2023</DatumVan> <DatumTm>01/01/2024</DatumTm> </cFilter> </GetMutaties> </soap:Body> </soap:Envelope> ", options = [ Headers = [ #"Content-Type"="text/xml; charset=utf-8", #"SOAPAction"="http://www.e-boekhouden.nl/soap/GetMutaties", #"Authorization"="Basic " & Binary.ToText(Text.ToBinary(SessionIDpass & ":" & "xxxxxx"), BinaryEncoding.Base64) ] ], Source = Xml.Tables(Web.Contents(Url, [ Content = Text.ToBinary(SOAPEnvelope), Headers = options[Headers] ])) in Source1.1KViews0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.