Solved: How do I merge multiple Sharepoint list into one l...

vjeshwar · ‎08-21-2021

Is there a way I can merge multiple sharepoint list into one common list wherein the updates that I do gets reflected everywhere,

mahoneypat · ‎08-21-2021

You can append individual queries to do that, but if you have multiple lists with the same structure on different sites, you can create a table that has 3 columns - the tentant url, site name, and list name, and pass those into a custom column in which you invoke the function share in this article/video. You can then expand that column of "Table"s to get your combined data.

Get Data From SharePoint Lists … But Fast – Hoosier BI

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

View solution in original post

mahoneypat · ‎08-21-2021

You can append individual queries to do that, but if you have multiple lists with the same structure on different sites, you can create a table that has 3 columns - the tentant url, site name, and list name, and pass those into a custom column in which you invoke the function share in this article/video. You can then expand that column of "Table"s to get your combined data.

Get Data From SharePoint Lists … But Fast – Hoosier BI

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Greg_Deckler · ‎08-21-2021

@vjeshwar An Append query?

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...