So it’s suddenly starting to become a bit clearer what Power Query is complaining about (even if we think it’s frustrating that it does complain about it!) Let’s “rebuild this data combination” As long as it’s an external source being combined with another query, we’re going to get smacked. The Filename() portion is calling a function to return the desired filename from a workbook table, (based somewhat on this approach.) We already know that works, but we also know that this is definitely pulling data from an external workbook (even it the file path is for this current workbook!) And to be fair, this would be the same if we were pulling from a web page, database or whatever.
Source=Excel.Workbook(File.Contents(Filename())), Looking at the first line, it is made up as follows: But it tries to merge that to an external data source which is called in the first line. Notice the issue here? The Merge step near the end references a query called DimShipper.
EXCEL 2016 QUERY EDITOR INSERT A NEW STEP CODE
Let’s have a quick look at the code that my friend sent: The answer is that you cannot combine an external data source with another query. So why when you do some merges does Power Query throw this error? For anyone who has worked with Power Query for a bit, you know that it’s perfectly acceptable to merge two queries together.
This message is a bit confusing at first. Please rebuild this data combination.” What Does This Mean? He was a bit frustrated, as he got a message from Power Query that read “Formula.Firewall: Query 'QueryName' (step 'StepName') references other queries or steps and so may not directly access a data source.
0 kommentar(er)
