Error In Excel Report Services In Share Point 2013. we're sorry. we ran into a problem completing your request

excel sharepoint sharepoint-2013 performancepoint
Ardalan Shahgholi picture Ardalan Shahgholi · Jan 14, 2014 · Viewed 13.7k times · Source

I use SharePoint 2013 and I want use Excel Services Report in Performance Point Service.

I have a SharePoint site that named http://KSCOLAP.

I deployed several report in my site with performance point service.

Now, I want create a Excel Report in performance point service:

I do this like below:

enter image description here

And then

enter image description here

And I config like this (for avoid of any error in my excel I use default sharepoint excel file):

enter image description here

And when I want view this excel file , I get this error in my browser:

we're sorry. 
we ran into a problem completing your request. 
please try that again in a few minutes

enter image description here

I follow all this ways in this link , but I can not fix it ?

Answer

Ardalan Shahgholi picture Ardalan Shahgholi · Jan 14, 2014

I found my fault :

In Central Administration

enter image description here

Go to Application Management

enter image description here

And then in Manage Web Application

enter image description here

I select my web site (Share Point - 80) and then select 'Service Connection'

enter image description here

Finally I Checked Excel Service Application And it work for me.

Related questions

Get the content of a sharepoint folder with Excel VBA

Usually I use this piece of code to retrieve the content of a folder in VBA. But this doesn't work in the case of a sharepoint. How can I do ? Dim folder As folder Dim f As File Dim fs …

Read More
Can two or more people edit an Excel document at the same time?

I have a SharePoint 2010 site with a document library for storing Excel files. If someone is editing an Excel file (using stand-alone Excel, not Excel services), everyone else will be forced to open the file read-only until the first person …

Read More
Open an Excel file from SharePoint site

I'm trying to open an Excel file from SharePoint using VBA. Because the file I'm looking for might be different each time I run the macro, I want to be able to view the SharePoint folder and select the file …

Read More