Appending Sharepoint lists into 1 query and refreshing

[jcastr02]

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?

[v-frfei-msft]

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.