Formula Firewall Query References Other Queries or Steps

[UncleLewis]

Hi all,

I am getting this error message:
Formula Firewall Query References Other Queries or Steps.

I am getting the filepath and filename as Named Ranges from the Excel Workbook

filepath : \\corp\entity1\dept\entity2\finance\revenue\team\estimate\11-Nov\

filename : revenue_week 11132022.xlsx

I then reference the parameters in a staging query based on this post from Ken Puls
But now the staging query is giving the same Formula Firewall error, even though it is only 5 lines to get the file and the sheet.

How can I beat the formula firewall error message?

Thanks,

-w

[v-jingzhang]

Hi @UncleLewis 

You may try: 

Going to: Options --> CURRENT FILE --> Privacy then setting the Privacy Level to "ignore the privacy levels and potentailly improve performance". For some people, this did the trick. 

Re: Formula.Firewall: Query references other queri... - Page 3 - Microsoft Power BI Community

Another blog that may be helpful: Chris Webb's BI Blog: Data Privacy Settings In Power BI/Power Query, Part 3: The Formula.Firewall Er...

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!