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:
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