Forum Discussion
Solved
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...
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
Super User
Super UserCan 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?