Forum Discussion

Marcin's avatar
Marcin
Helper V
9 years ago

Manage roles in Direct Query

Hi,

 

Is it possible to personalize view ( filter ) by username ( mail ) using Direct Query connection to SSAS Tabular ?

I want to create dashboard in my company where every employee can see its own content automatically . First I made it with import where Manage Role is possible, but its very problematic with data from SSAS Tabular.

 

Thanks!

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Marcin,

     

    Can you ensure you use the ssas tabular mode? Current power bi only support use "import mode" and "connect live mode" to connect the ssas database. Live mode not support row level security.

     

    Reference link:

    Row-Level Security with Direct Query

     

    Regards,
    Xiaoxin Sheng

    • Marcin's avatar
      Marcin
      Helper V
      9 years ago

      Hi,

      I am using connect live mode and I am aware that Row Level Security is not available in that mode.

      But I just want to ask If there is any other posibility to prepare dashboard or report where filter per user name / mail will work.

      Using import I need to write DAX Query to get data set form my SSAS base and tranfer all columns in to one tabel so that all filters would work. Using creator to Import I have to make realtionships again.

       

      I am looking for any advice how to make it in easrier way.

       

      thanks!

       

      Marcin

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Marcin,

         

        >>I am looking for any advice how to make it in easrier way.

        If you want to find a simple way to work through it, I'd like to suggest you refer to the link which I mentioned. it contain the tutorial about how to use SSDT create the RLS.

         

        In Power BI, when connecting SSAS tabular data source in DIRECT QUERY mode, it will directly take the role security defined within Tabular model. We can't "Manage Roles" for Tabular source in Power BI Desktop. To edit roles and corresponding row filters, you have to do it in either SQL Server Data Tools (SSDT) or SQL Server Management Studio (SSMS). Please refer to tutorial below:

         

        Tutorial: Dynamic row level security with Analysis services tabular model

         

        Regards,

        Xiaoxin Sheng