Archive

Latest Posts

Microsoft MVP Virtual Conference

Join me and piles of others in the MVP vConference (online). See below for more details. Here is a high level overview of the event: World-class free online conference that features technical content presented by Americas’ region MVPs that is open to the public More technical content (Level 200, 300, 400), less marketing 5 tracks: …

Read on

How PowerPivot Works with SharePoint (and How it Doesn’t)

A while back a customer wanted to combine external data sources and SharePoint together, and they thought the best way to do it was with Excel PowerPivot. Their intentions were in the right vein, but the possible path of execution didn’t actually exist. The idea being that they wanted to use a tool (Excel PowerPivot …

Read on

PowerPivot Data Refresh Debugging Process

If you’re unable to refresh the data and you’re seeing the following issue (below) when trying to refresh content, follow the steps described below. Note this was written with SharePoint 2010 in mind, but it should apply equally to SP2013. The “PowerPivot Data” value will be whatever the name of your connection is (see below). …

Read on

PowerPivot Gallery Thumbnail Debugging Procedure

I’ve had the odd occasion where the SharePoint PowerPivot thumbnails (in the gallery view) haven’t shown up properly for me, and a while ago I compiled a collection of debugging procedures. I figured I’d share this collection with the world. Some of these were meant more for SP2010, and SQL 2008 / R2, but many …

Read on

Practical Use of the DAX Search Function

I’ve found that when using the DAX search function that I often need to include the two optional parameters (“start num” and “not found value”).  SEARCH(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]]) I’ll explain the reasoning behind my statement.  What I’ve found when not using the optional parameters, if that if you have no matching value from your …

Read on

Error “Excel Window: PowerPivot Field List” Resolved

When trying to connect to data in PowerPivot everything seems to work fine when you’re setting up your data connections, setting up your relationships, and then once you go to return back to the Excel window by virtue of creating a PivotTable, you suddenly see the following error.   Message: Excel Window: PowerPivot Field List …

Read on

Quickly Crunching SharePoint Data with PowerPivot Using Only Your Mouse

To paraphrase a wise man, once you’ve got PowerPivot, “all your SharePoint’s are belong to us”.  I’m going to demonstrate how, using Excel 2013 (which has PowerPivot built right in – you just have to enable it), and SharePoint 2013 you can really easily be crunching some of your SharePoint data, without ever having to …

Read on