Forum Discussion
Appending queries from SharePoint list in PowerBI
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
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.
2 Replies
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?
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.
