Forum Discussion

richard-powerbi's avatar
richard-powerbi
Post Patron
6 years ago

Firewall problem referencing #sections[Section1]

I'm having problems with the use of #sections[Section1] and later on referencing anything made from that.

I use #sections[Section1] because I want to gather a list of my queries and combine queries that have ">DA" in their name.

I start with the code below:

Calendar table

let
Source = #sections[Section1],
#"Converted to Table" = Record.ToTable(Source),
#"Removed Errors" = Table.RemoveRowsWithErrors(#"Converted to Table", {"Value"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Errors", each Text.Contains([Name], ">DA")),
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Value"}),
#"Expanded Value" = blablabla

Calendar2 (ref from Calendar)

= Calendar

When I reference Calendar, immediately this error pops up:

Formula.Firewall: Query 'Calendar' (step 'LastStepInQuery') is referencing Query 'Calendar2' (step 'Source'), which was not part of its formula text.

I'm aware of the Formula.Firewall error in other situations and how te resolve it: https://www.youtube.com/watch?v=l4b8yRUpaoM

But when working together with sections[Section1], I'm completely stuck. I do not want to always ingore privacy level settings. Does anyone have an idea how to get around this?