Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
A classic error is occurring in Power BI Desktop.
The first time I do a full refresh after opening a .pbix file I get an error on one table:
A cyclic reference was encountered during evaluation.
And the other tables will then fail. All subsequent refreshes work OK.
The table on which the error occurs is different each time, and appears random.
The work-around is to disable parallel loading of tables, but this significantly increases the refresh time beyond acceptable limits.
We're using a custom API connector, so another work-around is to Clear Permissions in the Data source settings before the initial refresh - but obviously you then need to enter you API credentials again, which doesn't save any time!
This is still happening in the current version 2.68.5432.761 64-bit, and certainly in a few versions before that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.