Configuring automatic data refresh in SharePoint 2013 PowerPivot

After publishing the PowerPivot workbook in SharePoint, we can configure the scheduling for automatic data in workbook. To configure the data refresh we must have contribute level permissions to the workbook and must be windows domain account. Workbook must be checked-in at the...

Install PowerPivot Add-in for SharePoint 2013

PowerPivot for SharePoint collection of back and middle-tier services that allows getting PowerPivot data in SharePoint farm. If we are using Excel PowerPivot that contains the analytical data in SharePoint site, we must have to use PowerPivot services in server. PowerPivot for...

“An error occurred during an attempt to establish connection to external data source…” error in SharePoint Excel service PivotTable manual refresh

In SharePoint server 2013, to refresh the data manually in PivotTables need to go for Data -> Refresh All Connections as shown in the image below. While refreshing data I got an error like “An error occurred during an attempt to establish connection to external data source…”  After checking...

Add charts to SharePoint site using excel services

By using SharePoint excel services we can show excel worksheets, graphs and charts in the SharePoint site. We can create the charts and graphs by using excel power pivot. To create a chart in excel workbook, take an excel workbook with sample data to create a chart. Select...

Configuring Excel Services in SharePoint 2013 - II

In my earlier post, I have mentioned configuring excel services Global settings and Trusted file location. In this post we can see trusted data providers, trusted data connection libraries, user defined function assemblies and data model settings. Trusted data providers works...

Configuring Excel Services in SharePoint 2013

In my previous post, I have explained how to create excel service. In this post we can see how to Manage the excel service application. By navigating to manage excel service application page, we can see six links, allows us to manage the service application. By...