PowerPivot Scheduled Refresh Pt 3: Thin Workbooks

  What is a “Thin” Workbook? At Pivotstream, we came up with the term “thin workbook” to describe an Excel workbook that does not contain a PowerPivot model, but that DOES connect to another workbook that does, which we call a “core” workbook.  In other words, thin workbooks use core workbooks as their data source.  Others have called this “hub and spoke,” and I may even like that phrasing better, but hey, we’ve been using “thin and core” at Pivotstream…

Read the Rest

Data Refresh Twists/Turns Pt2 – Pivot Refresh

  “People looked at me differently.  They knew I was with somebody.  I didn’t have to wait in line at the bakery on Sunday morning for fresh pivots.” -Henry “DAX” Hill     That Second Refresh Can Really Bite You Back before the great distraction known as Donald Farmer hijacked this blog for a few days, I was talking about Scheduled Data Refresh.  Specifically, I left off talking about how refresh is really TWO refreshes – PowerPivot and Excel.  Here’s…

Read the Rest

PowerPivot Scheduled Refresh – Twists & Turns, Pt 1

“Rico, we'll need special tactical equipment. We're going to face extreme peril. The private probably won't survive.” OK, with a new year it’s time to get serious on the blog.  (Yeah, nothing says “serious” like cartoon penguins, but really, I *do* mean it).  This is gonna kick off a series of inter-related posts that I’ve had in my head for a long time now.  So buckle up, Rico.     Let’s say you’ve built a bunch of nifty PowerPivot workbooks. …

Read the Rest