This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

SharePoint 2013 PPS with Excel Power Pivot?

Question
0

Sign in to vote

Hi

I want to work with SharePoint2013 Performance Point Service with Excel Power Pivot as a Data Source (Excel file would be in Document Library).

Which Office version should i install?

What are the steps should i follow the configuration from scratch?

Thanks in Advance,

Poomani Sankaran

Monday, July 27, 2015 5:25 AM

Answers

0

Sign in to vote
Hi Poomani,

SharePoint 2013 Performance Point Service supports Excel 2013/2010/2007, I would suggest you install Office 2013 as it will contain more powerful functionalities as well as fixing issues which might exist in the previous versions.

About how to Create an Excel Services data connection by using PerformancePoint Services:

https://technet.microsoft.com/en-us/library/Ff191193.aspx

More information about how to configure and use Performance Service for your reference:

https://technet.microsoft.com/en-us/library/Ee748644.aspx

http://www.codeproject.com/Articles/783405/PerformancePoint-Services-in-SharePoint

https://technet.microsoft.com/en-us/library/JJ571736.aspx
Thanks
TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
- Proposed as answer by Dennis Guo Monday, August 3, 2015 12:59 AM
- Marked as answer by Dennis Guo Tuesday, August 4, 2015 12:53 AM
Thursday, July 30, 2015 9:41 AM