Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

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"

  • Anonymous's avatar
    Anonymous
    7 years ago

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

5 Replies