Update on Table Queries

Guest post by Scott Senkeresty

After completing this post on table queries, I celebrated by curling up with Microsoft Excel 2013: Building Data Models with PowerPivot.  It’s a great book by Marco Russo and Alberto Ferrari.  (I’ve read Rob’s book now multiple times, and I was even the tech editor on it, so it was time to step up and read the other leading book).

When I got to chapter 14 in the Italians’ book, two things happened:

  1. I saw page after page that looked incredibly similar to my blog post… making me feel like a complete imposter.
  2. I saw “the next level”.

The Italians don’t just bring data into a table via DAX.  They further manipulate the data (with standard techniques excel pros know and love), and then, link this newly created table back to their power pivot model for further analysis with DAX!  And it all responds to Refresh.   Totally.  Awesome.

6 Responses to Update on Table Queries

  1. Marco Russo says:

    Glad to know you liked the technique! :)

  2. Steven Rutt says:

    I know this is a 2013 feature, but are there any 2010 workarounds?

  3. Dennis Sevilla says:

    Sorry but dumb question. Does this mean you can update a table and re pull it into a PowerPivot model without redoing everything?

    • Scott Senkeresty says:

      It’s always true that if you create a powerpivot table that is linked to a “normal” excel table it is “live”. New rows and columns added to the excel table with get reflected in the powerpivot table.

      Is that what you were asking?

Leave a Comment or Question