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
Correct - the refresh isn't working some of the time. Shouldn't the refresh be binary (work or not work)?
Thanks
Some of the time !!!
It's either working or not working. If it was working and now it is not working it means that something has changed at the Data source level. Check it out then.
Ex : a date format is not correctly entered can break the refresh.
That's why I suggested it being a bug. Nothing changed in the data source between the error/failure and the good refresh.
Ok let's troubleshoot it:
Open a completly new Power bi File and Open a Blank Query in Power Query. Copy the M code from Sales Table and paste it into the new file. Close and apply.
Do you know how to do it?
Let me know please.