• Excel Web Access web part won’t display an Excel workbook that will display correctly with Excel Services (xlviewer)

    Issue In some scenarios, an Excel Web Access web part won’t display an Excel workbook that will display correctly with Excel Services (xlviewer). Instead of seeing the published workbook contents in the web part, there is just a placeholder...
  • BISM icons not present in SharePoint 2013 Library

    We have worked several cases where BISM icons are no longer present in a SharePoint Library. In the below screenshot you can see the icon is a blank square. We have found that the mapping is no longer present in the DOCICON located in one of...
  • 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...
  • SQL 2012, PowerPivot Management Dashboard Processing Timer Job fails

    Issue: The PowerPivot management dashboard does not show all usage data like it is suppose to and you see that the PowerPivot Management Dashboard Processing Timer Job fails. You may see errors like: "Call to Excel Services returned an error"...
  • Excel Web Access Web Parts & Remote Blob Storage - "We don't know what happened, but something went wrong."

    We have seen several cases where customers can view an Excel Workbook in the browser, but not in the Excel Web Access Web Part. They are seeing the below error in the Excel Web Access Web Part: “Excel Services We don’t know what happened...