Merging muliple tables in powerpivot

Question

I have 4 reports that I am downloaded into PowerPivot which create 4 seperate tabs in the power pivot window.

They all have the same column headers

How do I combine them into one data table? (one tab in powerpivot)

Answer 1

It is a liitle too late to combine information once you have put it in the PowerPivot window.

You can use this technique (or a variant of) prior to loading in PowerPivot.

http://blog.contextures.com/archives/2010/09/06/powerpivot-from-identical-excel-files/

Answer 2

I am following instructions on how to do this, per the link in the previous mesage from a contributer, but it is not working.

I watched the included youtube demo, followed the instructions to the letter (I thought) but not working for me.

What am I missing or doing wrong?

SELECT [GFT_Servers$].*   FROM [GFT_Servers$]

UNION ALL SELECT * FROM 'http://devsite/desktop/Shared Documents/PatchReports/Patch Compliance Reporting/gti_servers.xlsm'.[GTI_Servers$]

Answer 3

Hi blumm1,

Please refer to the following article to combine tables in PowerPivot:
Adding Value to PowerPivot Data in Excel 2010: http://msdn.microsoft.com/en-us/library/office/gg670985.aspx

Regards,
Bin Long

---

Bin Long

TechNet Community Support

Answer 4

Hi blumm1

In PowerPivot, you can't "combine" 4 tabs into one, with the exception of the 'Paste Append' feature in which you can copy each table in the clipboard and then paste append it (design tab in the powerpivot window).   Other than that, you can use relationships and DAX calculations to use data in multiple tables to create a consolidated view:

http://javierguillen.wordpress.com/2012/07/28/merging-data-in-powerpivot/

---

Javier Guillen
http://javierguillen.wordpress.com/