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

This article is based on usage of Performance Point services with SharePoint 2013. Basically I am trying to generate an excel report with the help of performance point service.

Entities:

1.   SharePoint 2013

2.   Performancepoint Services

3.   Excel Services

How to reproduce the issue / error?

Here are the details:-

1.   Open the dashboard designer

2.   If you have already created the data connection then it’s good, if not then right click on the data connection and create a new.

3.   Once that done then you will get that external data i.e. SP list, SQL data etc inside the dashboard.

4.   Right click on data source ->select New -> Report

5.   Select excel services

6.   Click OK

7.   Once you will see the excel file selected in the “excel workbook” location then click on ‘View’

That’s it – You will get the error as mentioned below-

Error message:

We’re sorry. We ran into a problem completing your request. Please try that again in a few minutes.

How to fix this issue?

Here is the resolution:

1.   Open the Central administration

2.   Application management

3.   Manage web applications

4.   Select the web application where your site resides underneath

5.   Manage service connections

6.   Select the Excel Services Application

7.   Click OK

That’s it – You are done! Your issue will be resolved J

In case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Note: If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Product Applies to:

1.   SharePoint 2013

2.   SharePoint 2010

3.   SharePoint Foundation 2010

4.   SharePoint Foundation 2013