Refresh failed : A cyclic reference was encountered during evaluation

[AmilaMG]

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

[v-stephen-msft]

Hi @AmilaMG ,

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]

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

[lbendlin]

What do you have the #"Filtered Rows"  step for?  Seems redundant.

Incorporate RangeStart and RangeEnd into the query string instead of using the parameters option.

Or use the parameters option but check your syntax.  Chris Webb's BI Blog: Passing Parameters To SQL Queries With Value.NativeQuery() In Power Query And ...

[pthapa]

I have the #"Filtered Rows" step for filtering a date/time field (in this case is completion date) for incremental refresh. So, the RangeStart and RangeEnd are two parameters that is used to filter the data for incremental refresh.
How do I implement in the query?

[lbendlin]

You already do that in your Stored Procedure. No need to do it again.

[JamesWick]

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