Archive

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 …

I recently was working with a customer and trying to get a PowerPivot workbook working. We were running into the following error. I found the following blog post, which helped me get past the issue. http://www.bidn.com/blogs/DevinKnight/ssis/5362/dealing-with-power-pivot-to-tabular-upgrade-errors The recommendation in the blog post is as follows: Translation: The Service Account that is running the SSAS Tabular …

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). …

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 …

Power BI has reached a new milestone going full plaid… err, more like General Availability.  Of course, it’s not generally useful to anyone who’s not at least partially using Office 365.  The link to the GA announcement is below.  The pricing is a bit wowsers until you start to realize what you’re getting for that …

I ran into this today at a customer, where they had SharePoint 2010 with PowerPivot/Analysis Services and Reporting Services installed on SQL Server 2012.  They were trying to view an Access Services Report, which takes advantage of the SharePoint Reporting Services integration – this was throwing an error in the UI.  However, as they were …

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 …

If you’re getting an error on load of PerformancePoint about it being unable to load (basically you get a Windows error that your application failed to launch successfully – such as “PerformancePoint dashboard designer has stopped working”), the link below could resolve your issue (it worked for me).  http://support.microsoft.com/kb/981692 Basically this will reset all your …