Forum Discussion
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"- Anonymous7 years ago
I was able to find the solution. I aggregate the columns in my staging table and it had no issues.
5 Replies
- v-piga-msft
Resident Rockstar
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.
Best Regards,Cherry
- AnonymousNot applicable
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
Resident Rockstar
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