Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
Solved! Go to Solution.
I was able to find the solution. I aggregate the columns in my staging table and it had no issues.
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
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?
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
I was able to find the solution. I aggregate the columns in my staging table and it had no issues.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
56 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |