Forum Discussion

KimStahl94's avatar
KimStahl94
Helper I
4 years ago

Formula.Firewall Error which disappears after reloading the data model in PBI Desktop

Hi there, I was wondering if anyone could help me after I did not find any solution that helped me removing the following error: Formula.Firewall: Query 'Query1' (step 'Source') references other qu...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago
(Every merging step is executed in a seperate query)

Per my current understanding (and I may be wrong) that is the issue.  To avoid the formula firewall you should keep everything in the same partition.

  • KimStahl94's avatar
    KimStahl94
    Helper I
    4 years ago

    Hi @lbendlin,

    thanks for your answer. In my understanding a partition is created after a merging step is executed. That is why I changed my query from the single query (left)  to the three queries (right).

     

    How could I keep it all in the same partition if a new partiton is created after the merge? Or am I getting the term partitions wrong? 
    Important note: Privacy Levels are all set to organisational. Shouldn't the firewall not be a problem then?

    Regards
    KS

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Avoid merging at all cost.  Either do the joins further upstream, or use separate dataflows, or let the data model do the work for you.

      • KimStahl94's avatar
        KimStahl94
        Helper I
        4 years ago

        Hi lbendlin 
        I'm trying this out at will let you know if it works. Unfortunately I have not been working with dataflows yet. All merging steps are executed in the end of my query. I will let you know how things turned out.
        But thanks so far, I really appreciate it!
        Regards
        KS