Forum Discussion
"Expression.Error: A cyclic reference was encountered during evaluation." After Remove Row Datasourc
Thank you for your reply.
Unfortunately I do not know how to, as it does not give an error in the M-Query:
*Removed*
When I press the different step in the "APPLIED STEPS" it gives me the following error when I press on the first step:
Expression.Error: We cannot convert the value 0 to type Text.
Details:
Value=0
Type=[Type]
Community SupportHi, Anonymous
The screenshot displays your private sharepoint url information. Please mask sensitive data before uploading for safety. Thanks.
About the issue, It is not to say that there is something wrong with the symbol. Instead, you may click from the upper step to the lower step in turn, and see which step appears the corresponding error message.
Best Regards
Allan
Hi Allan,
I have deleted the photo, thanks for giving me the notice.
I have gone through all steps and it seems these steps give the error:
Whereas the rest give this:
The issue here was that under "Applied Steps", the step before "Changed Type1" was referencing "Removed Columns3" when it should have been referencing "Removed Columns2". Had you simply changed the number "3" to a "2" at the end of the name, the query would have worked. 🙂
- v-alq-msft
Hi, Anonymous
I wonder if 'Removed Columns2' step can get the result normally. If not, please find out the last step which can get the result normally.
Best Regards
Allan
