Forum Discussion
Solved
Cyclic Reference Error on Initial Refresh
I am getting the dreaded "A Cyclic reference was encountered during evaluation" when I refresh my Power BI desktop report file. However, I only get the error when I kick off the initial refresh after...
I solved the problem by uninstalling the Microsoft Store version, and using the regular download. No problems since then.
The issue is with the DB/schema parameter in the PBI Desktop version of April 2022. If you replace the parameters with the actual value it works.
In case you cant publish without using parameters, consider using previous versions such as March 2022. (It works in PBI March 2022)
You can download the previous version from the below link.
https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-desktop
Until we have the fix available in April 2022 version, you can use the previous version as a workaround.
Cheers.