Forum Discussion

jcastr02's avatar
jcastr02
Icon for Post Prodigy rankPost Prodigy
7 years ago

Appending Sharepoint lists into 1 query and refreshing

I have a total of 18 different Sharpoint lists as queries in BI.  I'd like to append all the queries together onto a new table.  My question is if new data is added in the sharepoint list and I refresh, will the data refresh on the newly created table everytime?

Need Help

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi jcastr02 ,

     

    Assuming they are using the same data structure, you can use the append queries part of PowerQuery and then choose the Three or more tables option. Atfer that, you can keep the data update to date.