Expression.Error: Evaluation resulted in a stack overflow and cannot continue

[Jonakam01]

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:

[v-eqin-msft]

Hi @Jonakam01 ,

Please refer to this similar thread:

https://community.powerbi.com/t5/Desktop/Expression-Error-Evaluation-resulted-in-a-stack-overflow-an...

https://community.powerbi.com/t5/Power-Query/Data-Flow-PowerQuery-Error-Evaluation-resulted-in-a-sta...

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.

[PhilipTreacy]

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