Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Refresh failed : A cyclic reference was encountered during evaluation

I have power bi desktop report that needs to refresh. when i hit refresh it gives me the error "A cyclic reference was encountered during evaluation".

This report consist of ODBC snowflake queries which has "select * from table" for odbc query. And there is no merges or append queris. This refresh worked for 2021 December update but for newer versions this issue remains same. 

 

Do anyone have some idea regarding this? Please help

Need Help

8 Replies

  • nmckeown1's avatar
    nmckeown1
    Helper II
    1 year ago

    This is an old thread, but I had this issue in 2024.

     

    I went into power query editor, and refreshed it there. Came back out and refreshed it in desktop and it was solved.

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      I see this often with the latest versions. Yell at the clouds and refresh again, that makes the message go away.  Yet another meta data format change.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    This can be displayed with the error "Local file header is corrupted". All connections are connections to the API, not files. Again, clicking Update will always work the second time.

     

    Hope this helps,
    J Wick

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Did you check your steps in the applied steps? You may find which step is the problem.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • pthapa's avatar
      pthapa
      Post Patron
      2 years ago

      Hello,
      Let me first expalin my scenario:
      I am trying to do incremental refresh on the dataset using stored procedure with Start Date and End Date as parameters. When the date field is filtered with these parameters as you can see them on code below from advanced editor, when closed and applied the steps, it throws the following error. Couldn't find the answer on any blog posts online.
      Here is the error I get;

      Any help would be great.

      thanks,

      pthapa