Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Row Level Security not working in Analysis Services with Power BI Report Server

Hi,   I set Row Level Security but users can still see all the records even if they are not allowed to.   At the same time it works fine when using DAX query from inside SQL Server Management Stu...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Greg for replying, yes, I am doing the same steps except I am doing it in directly in SQL Server Analysis Services.

    It also works fine if I query the model using DAX. The problem happens in PBI RS only. 

    • v-diye-msft's avatar
      v-diye-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous 

       

      It was a bug known as awareness before, but was fixed by the EOD 3/4/2020 . could you please try again?

      If still not work, please kindly raise it to the support team for better research.
      https://powerbi.microsoft.com/en-us/support/ 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thank you v-diye-msft , How can I download the fix please?

         

        Is it a fix for Power BI Desktop RS or SQL Server Report Server?

         

         

        I am using Analysis Services onprem version 14.0.249.28