Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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

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:

Query used to Invoke the Function to grab all the years from the parameter used in the URL.jpgYear Parameter which will be used to generate the list of years.jpgDaily Box Office Table from web site.jpgDaily Box Office Function to get Year.jpg

Frequent Visitor

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.  

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors