Excel Services & PowerPivot for SharePoint

Troubleshooting Excel Services and PowerPivot for SharePoint rendering and refreshing in the browser.

Browse by Tags

Related Posts
  • Blog Post: Configuring BI Semantic Model Connections (BISM files) to PowerPivot Workbooks in SharePoint 2013

    Many customers come to us with questions surrounding the use of BISM files. Primarily why should they use them and how to configure them. In the following I will attempt to answer both questions. Why: When you upload a PowerPivot workbook to SharePoint, SharePoint is intelligent enough to create...
  • Blog Post: PowerPivot Management Dashboard - Post Install Configuration

    When you first install PowerPivot for SharePoint, there are some configuration tasks that need to be completed to get basic functionality working for the PowerPivot Management Dashboard, as well as to get the groundwork laid out for data refresh and slicing inside of workbooks. While not difficult...
  • Blog Post: Power View Sheets not rendering in the browser

    If you are using a Power View Sheet and it is not rendering in the browser (see below screenshot): You will want to verify if you are using Office Web Apps Server 2013 (WopiFrame.aspx) to render the workbook by examining the URL: URL Example: http://servername/sites/BICenter/_layouts/15/...
  • Blog Post: Excel Services - Using a SharePoint List as a data source

    Since Excel Services inception (SharePoint 2007) users have been attempting to consume a SharePoint List in Excel Services. Unfortunately this is not supported. I will explain why and I will also provide a workaround using PowerPivot. If you are unsure whether or not you are using a SharePoint list...
  • Blog Post: What is PowerPivot for SharePoint? Part 1.

    I find myself explaining PowerPivot to customers over and over. Most understand parts of how it works but not the whole story. I will touch on two parts; PowerPivot for Excel and PowerPivot for SharePoint. Part 1: PowerPivot for Excel PowerPivot for SharePoint is nothing without the Excel Rich...