Formula.Firewall invoke function from list of years with a source coming from a web site

[lkaneff]

I have a function where I specify a list of Years to grab from a website and output that data as a table. However I am getting Formula.Firewall error.  I'll post screen shots of my queries because I have no idea how to fix it.  It should combine all the years together when I invoke the function.  Thanks for your hel

Function Folder

Daily Box Office:

[lkaneff]

So there is absolutely no workaround unless I disable privacy setting which I don't want to do.  If there is another way I would really like to find a solution to this.  

[lbendlin · Accepted solution]

Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn

Chris Webb's BI Blog: formula firewall (crossjoin.co.uk)

Power Query M Primer (Part 13): Tables—Table Think II | Ben Gribaudo