WebOct 5, 2024 · 4 - Solutions. #1 Keep everything in the same query: #2 Instead of getting the file/folder path value from the first data source/query, get the actual content as very well explained in this video. The above example uses File.Contents function. The challenge is the same with Folder.Contents. WebJul 10, 2024 · Formula.Firewall: Query 'Issues' (step 'Invoked Custom Function') references other queries or steps, so it may not directly access a data source. Please rebuild this …
firewall - Power Query - Dynamically pass a file path into File ...
WebMar 12, 2024 · Formula.Firewall: Query ‘Merge1’ (step ‘Source’) is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination. Formula.Firewall: Query … WebSep 15, 2024 · Formula.Firewall: Query 'StagingTable' (step Filtered Rows) references other queires or steps, so it may not directly access a data source. Please rebuild this data combination. I have had this issue before and fixed it after using this link - click here. tow hitch step foldable
excel - Query referencing another query - Stack Overflow
WebJun 18, 2024 · It’s an excellent article by Ehren von Lehe of the Power Query dev team that contains the first fully detailed explanation of how the Power Query Formula Firewall and data privacy settings actually work. Called “Behind the scenes of the Data Privacy Firewall” you can read it on the Power Query MSDN forum here: WebMay 17, 2024 · After pushing the following button several more steps are added to the script, which now looks like this: Afterwards I get the following message: Formula.Firewall: Query 'Testfolder' (step 'Expanded Table Column1') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. WebMar 1, 2024 · These Formula.Firewall errors are the result of Power Query’s Data Privacy Firewall (aka the Firewall), which at times may seem like it exists solely to frustrate data analysts the world over. Believe it or not, however, the Firewall serves an important purpose. In this article, we’ll delve under the hood to better understand how it works. tow hitch subaru