|
Article ID: 3016518 - View products that this article applies to. On This PageSymptoms
Assume that you have an Excel workbook in a PowerPivot gallery in Microsoft SharePoint 2013 with a SQL Server 2014 PowerPivot instance. The Excel workbook contains a PivotTable that connects to a .bism file, and the .bism file points to another Excel PowerPivot workbook in a SharePoint PowerPivot gallery. When you click a slicer in the Excel workbook, you receive the following error message: "External Data Refresh Failed An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: <URL>" Collapse this image ![]() If you run a SQL Profile Trace against the POWERPIVOT instance in Analysis Services, you receive the following error message: "You do not have permission to perform the requested operation" Collapse this image ![]() ResolutionThis issue was first fixed in the following cumulative update of SQL Server. Cumulative Update 5 for SQL Server 2014 |
Contact us for more help |




