trouble with table relationships.

[tony0217]

since there seems to be no way to join two tables together in powerpivot (which is really lame). Is there any way that i can work with both tables at once? Once i get my millions of records into powerpivot all i need to do is filter them. no fancy pivot tables or charts, just a filter on a couple columns.

lets say i have 10 million records in table 1, and 10 million records in table 2.. if i cant join them how can i filter them both at the same time? is there a way that i may have the two of them join together in a new table?

thanks in advance. youre smart, so i know you can figure this out.

 

[miguel.escobar]

Question, have you ever tried Power Query? is this a tool that you'd be able to use?
check out this video:
Combine Multiple Files or Append All to one Table - Power Query a.k.a. Data Explorer for Excel - YouTube

I used multiple files but you can combine multiple Queries or tables from different sources with the "Append" option of Power Query.

Hope this helps!

 

[JEB85]

Thanks, I will have a look!