I recently performed an installation of both PowerPivot and Reporting services for a customer that was running SharePoint 2013. In preparation for the installation, the customer had made the SQL… Continue reading Problems Installing PowerPivot for SharePoint and Reporting Services From SQL Server 2012 SP2 on SharePoint 2013
Tag: PowerPivot
How to Connect to PowerPivot Workbooks With PerformancePoint
Scorecards, KPIs, and analytic charts and grids are at the core of PerformancePoint’s value proposition. In order to effectively work with them we need to work with a multidimensional data… Continue reading How to Connect to PowerPivot Workbooks With PerformancePoint
Don’t Update Your Power Query After Building a Model
Power Query can be a very powerful data acquisition and transformation tool, and Power Pivot is great for modifying imported models. While it isn’t always crystal clear where to perform… Continue reading Don’t Update Your Power Query After Building a Model
Setting Up Reporting Services and PowerPivot With SharePoint
Yesterday, I had the privilege of being the guest presenter of a hands on webinar organized by Cloudshare. The topic was how to install and configure both SQL Server Reporting… Continue reading Setting Up Reporting Services and PowerPivot With SharePoint
Troubleshooting and Removing a Failed Installation or Upgrade of PowerPivot for SharePoint
I recently had the opportunity to perform an upgrade of PowerPivot from SQL Server 2008 R2 to SQL Server 2012 for a customer with a relatively large SharePoint farm. Their… Continue reading Troubleshooting and Removing a Failed Installation or Upgrade of PowerPivot for SharePoint