Forum Discussion

BeckyH1324's avatar
BeckyH1324
Frequent Visitor
4 years ago

Append Queries: Stack Overflow Error

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 f...
Need Help
BeckyH1324's avatar
BeckyH1324
Frequent Visitor
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    BeckyH1324
    Frequent Visitor
    4 years ago

    Can you please provide steps on how to do that?