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