Formula.Firewall: Query references other queries, so it may not directly access a data source.

[Anonymous]

I am trying to figure out why this is receiving the the Formula.Firewall error. Can anyone please tell me what is causing the error?

let
    Source = Passing,
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Season", "PlayerName", "PlayerShortName", "PlayerLastName", "Team", "SeasonPlayerTeamKey"}),
    #"Invoked Custom Function" = Table.AddColumn(#"Removed Other Columns", "fxGetQBProfiles", each fxGetQBProfiles([Season], [PlayerName])),
    #"Expanded fxGetQBProfiles" = Table.ExpandTableColumn(#"Invoked Custom Function", "fxGetQBProfiles", {"PlayerURL", "Position", "PlayerImgURL"}, {"PlayerURL", "Position", "PlayerImgURL"})
in
    #"Expanded fxGetQBProfiles"

[v-piga-msft]

Hi @Anonymous,

Ken Puls blogged about this here

http://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/

In addition, you could refer to this two similar threads which has been solved.

https://community.powerbi.com/t5/Desktop/Formula-Firewall-Query-references-other-queries-or-steps-so-it/td-p/491528

https://community.powerbi.com/t5/Desktop/Formula-Firewall-Query-references-other-queries-or-steps/td-p/355582

Best Regards,

Cherry

[Anonymous]

I have read through everything you sent and I am still not understanding the issue. I have a staging table for the variables I am trying to pass into the function to give me the values. What am I missing?

[v-piga-msft]

Hi @Anonymous,

What's the kind of passing source? So that I can have a test to reproduce your scenario to research for this issue.

Best Regards,

Cherry

[Anonymous · Accepted solution]

I was able to find the solution. I aggregate the columns in my staging table and it had no issues.

[v-piga-msft]

Hi @Anonymous,

It's glad that you have solved your problem.

Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best  Regards,

Cherry