Forum Discussion
Merge 5 SharePoint lists
what about append instead of merge? That option is available for 3 or more tables.
Only issue I'm running into is the ID column we use and Power BI doesn't like the dup values.
I'm trying to create a new column which is just the ID + string value for each list, but can't get a number + string to join.
There's gotta be something I can do to convert the number to a string so the concat will work.
I should have specified earlier.
Append is essentially adding rows to the data set. It requires all datasets to have the same exact column headings and data types, then pieces them together
Merge is how PowerQuery handles joins between tables.
This article does a good job explaning it. http://radacad.com/append-vs-merge-in-power-bi-and-power-query
The question is, if you have 5 sharepoint lists that are the same, then you can append them all. If they don't contain the same information, then you will have to merge them using the proper joining mechanisms.