Power Pivot Tables

[Aliq2014]

Hi, I'm new to the power pivot world. I have a question can I join tables from the same server but different databases.
For example, server name mvmppacsdb01 database name ACVDW
server name mvmppacsdb01 database name ACSQL.

I need to do a left join between this database environments. I can only do a equal join by creating relationship between their primary key from each table.

Any suggestions?

Thanks,

Aliq2014

 

[Matt Allington]

Power pivot is not a relational DB. Every relationship is one to many (excel 2010 - 2013) and while technically it is a left outer join, it is better to think of the 2 tables as lookup tables and data tables (or dimension tables and fact tables if you like). So if you tables are one of each, then just bring them in from the 2 different sources and join them - no issues. If you need to combine them into 1 single table with a left outer join to make 1 new data table, you would be best to bring both tables into power query and join them there, or do it in one of your servers.

 

[Aliq2014]

Thanks, for the information. I'm trying to learn more about power query do you recommend any sites for references?

 

[Matt Allington]

Yes. I have lots of material I share at my blog and knowledge base. Http://xbi.com.au/blog
Also my book is getting very good reviews from people learning. Http://xbi.com.au/learndax
the other site with good material is PowerPivotPro - Transforming your Business with Power Pivot and Power BI.