February 2013
Intermediate to advanced
304 pages
8h 26m
English
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.
Listing 23.8. Changing the Maximum Number of Sources in a Query
Set-SPAccessServiceApplication -Identity "Access Services"-SourcesMax 8
Many lists used within a query could affect performance. Limiting the number of lists ...
Read now
Unlock full access