Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

January 2019 release issue

Dear Support,   We're facing the issue that when the checkbox "apply security filter in both directions" is clicked, the report cannot be uploaded to the report server. But this is needed in order ...
Issue
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Am I the only one facing this issue? Or does somebody else has the dynamic RLS running?

 

Regards

  • Mithrilendil's avatar
    Mithrilendil
    Frequent Visitor
    7 years ago

    Same thing here, we can't upload reports with "security filter in both directions"

    • PowerBI_Develop's avatar
      PowerBI_Develop
      Regular Visitor
      7 years ago

      I get the same error.

      • PowerBI_Develop's avatar
        PowerBI_Develop
        Regular Visitor
        7 years ago

        In PowerBI Report Server Logfile I found following error message:

         

        "Table 'Table_Name' is configured for row-level security, introducing constraints on how security filters are specified. The setting for Security Filter Behavior on relationship 'Relationship_Name' cannot be Both."

         

        I found a hint that it occurrs on SQL Server 2016 Analysis Services.

         

        "Error when you use SecurityFilteringBehavior enumeration in SQL Server 2016 Analysis Services"

        https://support.microsoft.com/en-us/help/3183440/error-when-you-use-securityfilteringbehavior-enumeration-in-sql-server

         

        And should be solved after installing Cumulative Update 2 for SQL Server 2016. But I use SQL Server 2017 Analysis Service 14.0.3.441.

        It seems that the error still occurr on SQL Server 2017.