Append Queries: Stack Overflow Error

[BeckyH1324]

I have imported several SharePoint online lists into Power BI. I am trying to append these 7 lists into 1 to try to make sorting through things easier. When I try to append them, I keep getting the following message:

I've tried appending any range from all of them at once to only two

I've run the traces and cannot find any logs with "ValidationException" or "Microsoft.Mashup.Container.NetFX40" (all of mine are 45)

I've confirmed that the tables I'm appending have the same column labels

These are not big tables. I've also tried appending two tables that don't contain data and still get this error

Does anybody have any idea why I'm getting this error? Is this the best way to do what I'm trying to do?

Any help is appreciated!

[BeckyH1324]

Hi Arul! Thank you for the reply. Unfortunately, I don't think those links are helpful. It could be in part because 1. I don't fully understand how to achieve their solution and 2. one is talking about Kusto (and I have no idea what that is). I'm not a super knowledgeable Power BI user. 

[Anonymous]

Hi @BeckyH1324 ,

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,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BeckyH1324]

Can you please provide steps on how to do that?

[Arul]

@BeckyH1324 ,

check this thread it might help you,

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... 

Thanks,

Arul