Appending queries from SharePoint list in PowerBI

[adi4]

Hi Everyone,

I'm trying to append 5 queries from a sharepoint list and I get the below error. Please note I have removed the columns I do not want before appending but I still get the below error. Can anyone please help with this? 

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

Thank you

[v-yingjl · Accepted solution]

Hi @adi4 ,

Simliar issue has been submited previously(ICM: 219724212, 224968762)

You can try these workarounds from PG team provided:

- Workaround #1:

Call Table.AddIndexColumn on each source query before using Table.Combine. Or add a new step to each query using "Index Column" button under Add Column tab before combining tables.

- Workaound #2:

Call Table.Buffer on each of the tables being combined before calling Table.Combine.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jennratten]

Can you please reply with some screenshots of your queries that you are trying to append and paste the scripts from the advanced editor for each?