Forum Discussion
Refresh failed : A cyclic reference was encountered during evaluation
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.
Post PatronHello,
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
Super User
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 Power BI (crossjoin.co.uk)
- 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.
