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 luck...
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




Anonymous's avatar
Anonymous
Not applicable
2 years ago

That's the problem - this error pop up message continues to come up, but then allows me to refresh the dataset with no problems or changes being made. 

 

This is why I thought it might be a bug, since it still works and allows the file to refresh with no changes being made. 

aj1973's avatar
aj1973
Community Champion
2 years ago

It's not a bug. The refresh is just not working.

As I said, you need to verify the applied steps one by one and see if you can combine some steps in one.

My doubts still up for these steps

and why so many merged queries!!