Workbook with MSAS Data Source Has Slow Performance After Upgrading from Tableau Desktop or Server 9.0

Published: 08 Mar 2018
Last Modified Date: 01 Dec 2019


After upgrading to Tableau Desktop or Server 9.1 or a newer version from 9.0 or earlier, some workbooks with MSAS data sources perform more slowly.


  • Tableau Server 9.1 - 10.5.0
  • Tableau Desktop 9.1 - 10.5.0
  • MSAS


  • If any field contains an UNKNOWN_MEMBER value, upgrade to Tableau Desktop or Server 10.5.1 or a newer version. For more information, see Upgrade Tableau Desktop and Upgrade Tableau Server.
  • If the default sort order has been changed for a member in the cube, work with your database administrator to return the field to the default sort (generally alphabetical).





Collation mismatch occurred, requiring Tableau to use enumeration filtering rather than range based filtering, resulting in slower performance. 
  • When the field contains UNKNOWN_MEMBER, this behavior relates to a known issue which was corrected in more recent versions. 
  • When the field is sorted in a way that Tableau does not expect, a collation mismatch occurs.


Additional Information

  • Tableau matches against LROOT collation. For more information, see Root Collation at
  • Collation checking was introduced in Tableau Desktop and Server 9.0.7 to help ensure data accuracy.

Discuss this article... Feedback Forum
Did this article resolve the issue?