Using Power Query to Connect Tables for Reporting | Excel.TV, Episode 55 - Excel TV

Using Power Query to Connect Tables for Reporting | Excel.TV, Episode 55

An Excel Joke to Start Off...

Did you hear about the database developer that walked into a bar? They saw two tables and tried to join them. 

And that's what we're doing this week! Last week, as you might recall, I posted an overly complicated solution to this problem based on formulas.  

This week, I've simplified it all using a left outer join. This is a really cool feature that lets you treat Excel like a database. You can a very similar use of joins in Szilvia's video, by clicking here.

Watch the entire video to see how I join two different tables using name as the primary key! 

Get the Download File

Get the file by clicking this link.

What do you think? How do you connect tables?

Let us know in the comments.

  • Isaac says:

    I use this function pretty much daily. I’ve always heard that it is better to use power pivot though. The problem I have though with power pivot is that if there are more than one of the same value in each table, it doesn’t work. So I just use the merge query capability in get and transform. I never have any problems with it.

  • >