KB4018908 - 修复：SQL Server Analysis Services (多维模型中的Power BI Desktop忽略维度安全性)

应用对象

Microsoft SQL Server SQL Server 2014 Service Pack 2 - duplicate (do not use) SQL Server 2014 Standard - duplicate (do not use) SQL Server 2014 Developer - duplicate (do not use) SQL Server 2014 Enterprise - duplicate (do not use) SQL Server 2012 Developer SQL Server 2012 Enterprise SQL Server 2012 Enterprise Core SQL Server 2012 Standard SQL Server 2012 Service Pack 3 SQL Server 2016 Developer - duplicate (do not use) SQL Server 2016 Enterprise - duplicate (do not use) SQL Server 2016 Enterprise Core - duplicate (do not use) SQL Server 2016 Standard - duplicate (do not use) SQL Server 2016 Service Pack 1 SQL Server 2017 on Windows (all editions) SQL Server 2017 on Linux (all editions)

症状

假设将维度安全性配置为在 Microsoft SQL Server Analysis Services (SSAS) 多维模型中隐藏维度中的某些度量值，然后使用“连接实时”选项从 Power BI Desktop 连接到 SSAS 模型。打开维度时，所有度量值（甚至已拒绝访问的度量值）都会变为可见。