Operational Defect Database
BugZero found this defect 1308 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 10687745
KB4018908 - FIX: Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services (Multidimensional model) - Microsoft Support
Last update date:
7/21/2023
Affected products:
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)
Affected releases:
build lower than 14.0.3006.16
Fixed releases:
14.0.3006.16
Description:
Symptoms
Assume that you configure dimension security to hide some measures in a dimension in a Microsoft SQL Server Analysis Services (SSAS) Multidimensional model, and you then connect to the SSAS model from Power BI Desktop by using the Connect live option. When you open the dimension, all the measures become visible, and even those that you have denied access.
Resolution
This issue is fixed in the following cumulative updates for SQL Server: Cumulative Update 1 for SQL Server 2017 Cumulative Update 7 for SQL Server 2016 RTM Cumulative Update 4 for SQL Server 2016 SP1 Cumulative Update 6 for SQL Server 2014 SP2 Cumulative Update 13 for SQL Server 2014 SP1 Cumulative Update 10 for SQL Server 2012 SP3
