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 o...
Need Help
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