Forum Discussion
Queries blocked by error?
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 Desktop2) 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
When you click Refresh
Do you still get the error?
The step "Replaced value 25" refrences other queries or steps that is not supported.
You need to figure it out which one and check which one is not query folding.
In my opinion, looking at those many steps applied i think lots of them need to be re set or avoided.
No - I can refresh the preview with no issues and when I go back to main PBI interface I can hit refresh again and the proccess will run with no problems or complaints.
Regarding your commend about query folding, how can I determine which one is causing the problem?
Well done then! the issue is solved? by first refreshing it in Power Query!
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.