Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Queries blocked by error?

Hi - this error keeps happing with my query, but I think it's a bug. If I went ahead and refreshed the data straight away again, it would run with no issues. Is this a known problem or am I just lucky? 

 

And yes - I have rebuild the data combination, and the error comes back eventually even if no other changes are made. 

 

 

Thanks! 

 

Need Help
  • jaysgovindiya's avatar
    jaysgovindiya
    2 years ago

    Hi Anonymous 

    There are three possible ways to solve this issue:

    1) Simple solution is to set ignore privacy levels as per below screenshot
    From File -> Options and Settings -> Current File -> Privacy -> Check Ignore the Privacy levels option
    Note: This will work only in Power BI Desktop

     

    2) Set Proper Privacy levels
    Go to Data Sources Settings from Transform Data -> Set all sources privacy levels to Organization as per need.

    3) Replace step with combined code
    In this way you need to copy all the steps in target source which are required.
    Cyclic reference in Power Query - How to avoid? - Microsoft Community Hub




21 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

    Hi Anonymous 

    Open Power Query and verify the "Applied Steps", there must be an error somewhere.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Went back into Power Query, there are no errors or any code that the preview complains about. 

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    is your data source or data changed? you can check Replaced Value25 and modify that step to fix the issue.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      No - data source stayed the same, and the replace value statement is changing a specific name to a slighly different value. I'm not sure how to modify it and still have it do what I'm looking to acomplish. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Based on his post - wouldn't the error window have "Formula.Firewall" in it? Also, right after I got that error window I refreshed the data again and it worked with no complaints. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi all - thanks for the suggestions but I haven't been able to establish the root cause of the error. 

    • jaysgovindiya's avatar
      jaysgovindiya
      Helper I
      2 years ago

      Hi Anonymous 

      There are three possible ways to solve this issue:

      1) Simple solution is to set ignore privacy levels as per below screenshot
      From File -> Options and Settings -> Current File -> Privacy -> Check Ignore the Privacy levels option
      Note: This will work only in Power BI Desktop

       

      2) Set Proper Privacy levels
      Go to Data Sources Settings from Transform Data -> Set all sources privacy levels to Organization as per need.

      3) Replace step with combined code
      In this way you need to copy all the steps in target source which are required.
      Cyclic reference in Power Query - How to avoid? - Microsoft Community Hub




      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Thanks - step 1 worked for me. I haven't had that error pop up since I changed the privacy levels are per the screenshot.

         

        I appreciate the help! 

    • aj1973's avatar
      aj1973
      Community Champion
      2 years ago

      Can you please Open Power Query and screenshot all details please.

      All screenshots possible please.