Configure the Maximum Number of Sources in a Query
Scenario/Problem: You need to modify the maximum number of sources allowed in a query within Access Services.
Solution: Use the SourcesMax
parameter with the Set-SPAccessService Application
cmdlet.
The SourcesMax
parameter has a default value of 12
and determines the maximum number of lists that can be used in a query within Access Services. The valid range of values for this parameter is 1
to 20
. Listing 23.8 shows a sample modification of the maximum number of sources.
Set-SPAccessServiceApplication -Identity "Access Services"-SourcesMax 8
Many lists used within a query could affect performance. Limiting the number of lists ...
Get PowerShell™ for SharePoint® 2013 How-To now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.