Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 opening the file.
Each subsequent refresh runs without a problem. If I close the file and reopen it, the initial refresh will throw the error. Also, the table that throws the error is not always the same and there is no additional information provided.
This is a very straight forward file, with no append queries or other processes that create derivative tables. Basically, four tables from our local SQL Server database are imported, no manipulations or changes are made to the data.
I have been searching the interwebs for anything that can help me sort this out and have not found anything about the problem I'm having.
EDIT: I just tried refreshing the file on another PC we use for Power BI and I didn't get the cyclic reference error. So strange.
If anyone has any thoughts about how to diagnose this, I would be eternally grateful. If there is any additional information I could provide, let me know.
Solved! Go to Solution.
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-de...
Until we have the fix available in April 2022 version, you can use the previous version as a workaround.
Cheers.
Hi @CatPhish
Based on my test, i cannot reproduce the same issue. I would suggest you update the version of desktop and clear cache for the file. If it is not your case, you may submit a support ticket.
https://powerbi.microsoft.com/en-us/support/
Regards,
Cherie
Hi @CatPhish
Could you tell me if your problem has been solved? If it is, welcome to share the solution and mark it as solution. More people will benefit from here.
Regards,
Cherie
Sherie, I just advised Ehren, the tech on my original ticket, that this problem has started occuring again, but only on the PC that is running the February 2019 Update. The same file, when run on a laptop that is still running the December 2018 file is having no problem.
I've already tried clearing the data cache, but it did not correct the issues.
I solved the problem by uninstalling the Microsoft Store version, and using the regular download. No problems since then.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |