Forum Discussion
UncleLewis
3 years agoResponsive Resident
Formula Firewall Query References Other Queries or Steps
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 ...
v-jingzhang
3 years agoCommunity Support
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 Error
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!