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 icon where the workbook should be displayed, and there are no errors in the…

0

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 the two directories (dependant on the version you are…

0

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 a Data Model under the Analysis…

0

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" “Cannot query internal supporting structures for column 'Date'[Rolling52Weeks] because they depend on a column, relationship, or…

4

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 to do, these steps are often missed…

2

PowerPivot workbook with a PowerPivot connection to a SharePoint list cannot be refreshed manually in the browser (Data > Refresh All Connections) using Windows authentication in SharePoint 2013

Issue As we all know 🙂 with SharePoint 2013, manual data refresh in the browser (Data > Refresh All Connections) for PowerPivot workbooks will refresh data all the way back from the original PowerPivot data source, which is specified in the PowerPivot workbook's PowerPivot connection. This functionality is different with SharePoint 2010, where manual data…

1

Excel Services gives error when connecting to PowerPivot Workbook via .bism file, SQL Server 2014

Issue: User creates a PowerPivot workbook with Excel, and saves it to SharePoint. User creates a .bism file that points to the PowerPivot workbook and saves the .bism file to SharePoint. User creates second workbook that uses the .bism file to point to the first PowerPivot workbook as a data source. User views the workbook with Excel…

1

PowerPivot for SharePoint 2013 – Data Refresh with Power Query not supported

You may see a “Call to Excel Services failed” error when trying to perform a scheduled data refresh using PowerPivot for SharePoint on a workbook in SharePoint 2013 that has a Power Query connection to a data source. At this time, Power Query is not supported by SharePoint 2013 on-premise. Both data refresh in the…

10

PowerPivot for SharePoint 2013 – "Could not find the schedule for this work item"

You may receive the following error when running a scheduled data refresh on a PowerPivot workbook in SharePoint 2013 running PowerPivot for SharePoint: Could not find the schedule for this work item This error occurs when the workbook is checked out when the scheduled data refresh runs. Scheduled data refresh for workbooks that are checked…

0