Forum Discussion
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 w...
lbendlin
Super User
Super UserWhat 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 Power BI (crossjoin.co.uk)
pthapa
Post Patron
Post PatronI 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.