Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Row level secuirty from sql server to power bi desktop

Hi Team,   How to provide row level security to SQL Server and this security connect to power bi desktop?   Thanks sreenivasa
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi @kunuthuri，

 

How do you connect with the data source? There are three ways: Import, DirectQuery, Live connection.

 

There are two scenarios about setting Row level Security in Power BI about SQL Server.

 

1. If you connect the data source with import or Direct query , you could create Roles in Power BI Desktop under the Modeling, Manage Roles.

 

For this scenario, you could refer to Dynamic Row Level Security and Row-level security (RLS) with Power BI.

 

2. If you work with Analysis Services Tabular model in Live connection, you should create roles in the tabular model, the detail steps you could refer to Dynamic row level security with Analysis services tabular model and this article.

 

Best Regards,

Cherry

  • fvitalli's avatar
    fvitalli
    Regular Visitor
    8 years ago

    Hi v-piga-msft

     

    Beyond the two scenarios that you described, could I connect my Power BI Desktop to a SQL database with RLS trough an SSAS model? I would like to know if I can use the impersonation on SSAS to get and pass the user to the database and filter the data according to my RLS rules.

     

    Thank you,

    Fred

    • Fedda's avatar
      Fedda
      New Member
      2 years ago

      So, 4 years later... did you fint a solution to this?