Forum Discussion
Expression.Error: Evaluation resulted in a stack overflow and cannot continue
Please help with a workaround solution. I am trying to create a new query in an already existing report by using the GetData >Blank Query>Advance Editor. So I am using a data querying (which combined 2 tables from sharepoint folders) and transformation (Cleaning/moddelling) script from previous successful project/report. Each time I try to run this script into this existing report Power Query returns Expression.Error: Evaluation resulted in a stack overflow and cannot continue. I tried different solutions found on this forum but they don't seem to suit my issue. Below is the content of the script:
2 Replies
Hi Jonakam01
No script was included in your message.
Try breaking your query into parts. Just try the code that gets the tables from Sharepoint. Does that work?
If so, then add the transformation steps.
You may need to manually create the transform steps if your copy/pasted code breaks the query.
Regards
Phil
Hi Jonakam01 ,
Please refer to this similar thread:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
