Forum Discussion
Post PatronA cyclic reference was encountered during evaluation?
Post PatronHello Anonymous ,
Thanks for your reponse on this topic. Appreciate taking time to gather valuable informations and sharing with the community.
This issue is still not resolved and under investigation as of now. I am still researching why or how.
1. As per your advise, I tried another sample stored procedure without having [EnableFolding=true]; still the query will not fold.
2. And, I tried the query without sub-query on the sql, it still will not fold, just for your reference.
It will not fold after I filtered the date/time field. See below
Then get this error once close/apply:
Thanks,
pthapa
Post PatronHello all,
I wanted to provide some update to this topic though the issue is not exactly related to cyclic reference error.
I tired a stored procedure with Startdate and Enddate parameters that is already in the stored procedure.
Pass the RangeStart and RangeEnd parameters to the Startdate and Enddate and enable folding = true, the query folds without issues and able to apply incremental refresh to this dataset.
I followed the instructions from GuyInCUbe. Thank you Patric for sharing such wonderful tips in the video.
https://www.youtube.com/watch?v=-KXDpi_wyD4&t=196s
Hope this helps.
But I am still hunting to why a cyclic referene error comes up from my original post!!!
Thanks,
pthapa
Hi,pthapa
Has your problem been resolved?I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.