Forum Discussion

adi4's avatar
adi4
New Member
5 years ago
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...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    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.

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

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.