Formula Firewall error

[roboskoog]

I have a query that was working fine.  Now, when I try to refresh it I get the following error:

Formula.Firewall: Query 'Est Review Effort' (step 'Merged Queries1') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

The step is on a merge and I can read the sql server table I am trying to merge with.  I tried writing a query to pull the data instead of directly accessing the table and get the same error. I tried rebuilding the query starting at this step and it gets the same error.

Anyone know how I can fix this?

[tristanstcyr · Accepted solution]

Can you share your queries with us?

You can get all the queries at once using the Send-A-Frown feature. It will create an email with them in the body. You can copy-paste them as a reply in this forum, or send us the query by email through the Send-A-Frown feature and we diagnose the issue over email.

[Anonymous]

Hi, is there any solution to be provided here?

I dont seem to be able to solve some Formula.Firewall Errors..

Dont able to se why, all of my queries work in one report, but as I copy them to a new report they fail with formula.Firewall Error

[pqian]

@Anonymous The original workbook may have FW disabled. See this post

http://community.powerbi.com/t5/Desktop/Formula-Firewall-Query-Foo-references-other-queries-so-it-ma...