FIX: Error when a role that is defined with a restricted column is used to run a drillthrough query in SSAS

Applies to: SQL Server 2017 DeveloperSQL Server 2017 EnterpriseSQL Server 2017 Enterprise Core

Symptoms


Consider the following scenario:

  • You have Microsoft SQL Server Analysis Services (SSAS) installed on SQL Server in Tabular mode.
  • You connect the services through a user who belongs to a role that is defined with a restricted column in a table.
  • You run a drillthrough query on another column in the same table.

In this scenario when you run the query, you receive an error message that resembles following:


For example, you define Object Level security on the Reseller Sales table and Gross Profit column, and then then create a role that restricts it to Read permissions. The drillthrough query fails, and you receive the following error message:

Resolution


This problem is fixed in the following update for SQL Server:

Cumulative Update 9 for SQL Server 2017

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the standard terminology Microsoft uses to describe software updates.