Forum Discussion
Merge 5 SharePoint lists
Need is to merge the data from 5 SharePoint lists and produce 1 chart/report. Report Builder 3.0 is past option with just 2 lists, but 5 is causing more of a challenge. Anyone merged 5 SharePoin...
Absolutely, 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. Let me know if you have any other questions. Example below: