Union query in PowerPivot with external DB?

[fredcook]

We have several Progress Databases running on AIX. The structure of the databases are identical and they represent different divisions of our company. Currently I have an Excel pivot table that points to an Access table that is updated with a union query that combines the data from four databases into one table. Is there a way to create the union query in PowerPivot so I don't have to use Access? I have seen some examples of union queries for pivot tables and PowerPivot, but they have all been from other Excel files and not from external databases. Thanks for any advice!!!

 

[pai_da_mayra]

Have just been confronting this problem, and I think I have found the answer. The procedure is as follows:
1. Enter the query as it relates to one database, and save.
2. Go into Table/Table Properties and add the SQL code containing the UNION clauses, and click Save. The data from all of the relevant databases should now all be returned.

As an aside, I found the same issue occurring with SQL Enterprise Manager, and a similar solution seemed to work.