Hi

Can you please let us know how many (max) target application's we can create under 1 secure store service application? 

As we know, Manage Data Refresh feature is only available for PowerPivot Service Report and we can access it from Sharepoint to schedule the Workbook for Data Refresh.

As per our requirement, we need to build a interface to use this Schedule data refresh feature in a separate browser not from SharePoint. Please let us know how to build this interface, is there any option to use API Web Service.

Thanks in advance.

Regards

K.V.B.Gururaaja

Hi,

For your first question, refer to the following link:

https://social.technet.microsoft.com/Forums/en-US/ab7f24eb-0cbf-4101-931e-1f89446e2149/secure-store-service-target-application-max-number?forum=sharepointgeneral

For your second problem, could you offer a screenshot about what is your intention?

Besides, take a look at the article about  PowerPivot data refresh options:

http://www.sqlchick.com/entries/2012/11/17/powerpivot-data-refresh-options.html

Best Regards,

Lisa Chen

Forum Support
Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.