Symptoms

Consider the following scenario:

  • You create an SQL Server 2017 Analysis Services (SSAS 2017) tabular model on a powerful computer that has more than 6 cores.

  • You configure the Maximum Number of Connections property of the data source object in the tabular model database to a number that is much larger than 6.

  • You connect to the tabular model database by using the modern Get Data experience that is introduced in the latest SQL Server Data Tools (SSDT) and process a table that contains many partitions.

You may notice that only 6 partitions are processed in parallel which results in a slow performance.  

After you install this update you will notice the following:

  • This update increases the parallelism by removing the current limit of 6.

  • The maximum parallelism of external queries that can be executed by the modern Get Data experience is determined by the Maximum Number of Connections property of the data source object in the tabular model database.

Resolution

This improvement is included in the following cumulative update for SQL Server:

       Cumulative update 4 for SQL Server 2017

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

Latest cumulative update for SQL Server 2017

References

Learn about the terminologythat Microsoft uses to describe software updates.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×