Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

'Formula.Firewall: Query references other queries or steps' error

FWIW, if you all of a sudden come across this issue when your queries previously worked fine, Power BI might have errored on the Merge Queries steps in your queries.

 

Go to File->Options and settings->Options->Privacy. If you're like me, you have the Privacy Levels set to 'Combine data...'. Switch it to 'Ignore...', hit OK, and refresh the data. All my queries with Merges worked for me then. I then went back and turned the option back on to 'Combine data...', hit OK and refreshed the data, and everything STILL worked.

 

So, in my limited testing, just refreshing the Privacy Levels setting seemed to clear out the issue on my merged queries.

 

HTH

General Comment
Tips and Tricks

1 Reply

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Thanks for sharing your experience.

     

    Please give Kudos for support.

    If I answered your question, please mark my post as solution, this will also help others.

     

    Looking for German Power BI content? Visit my blog.
    http://www.thinkbi.de/