Excel Services - Query Warning

   You may receive the following warning dialog box when opening a workbook using Excel Services in SharePoint:     Be careful. This workbook contains one or more queries that might be unsafe. Do you want to enable these queries?   To suppress this and other warnings from Excel Services, go to SharePoint Central Administration…

9

What is PowerPivot for SharePoint? Part 2.

Now that we have a PowerPivot workbook in the Excel Rich Client, we are ready to publish that workbook to SharePoint. In “What is Power Pivot for SharePoint? Part 1” I discussed the Data Model and how it is a database inside of Excel.  When you publish/upload a regular Excel workbook to SharePoint, that file gets chunked up…

6

PowerPivot for SharePoint 2010 & SQL 2012 - Refresh in browser fails due to multiple "Process" Data Models in Analysis Services.

    When opening a workbook after a Schedule Data Refresh, the workbook does not open in Excel Services:     This is because after a Scheduled Data Refresh, the “Refresh data when opening the file” is checked.  This is by design, because after a Scheduled Data Refresh, the workbook’s Data Model is updated with…

5