DB_Lad8314's avatar
DB_Lad8314
Regular Visitor
4 years ago
Status:
Needs Info

Row Level Security

Hi,

 

I have to implement user wise data display in Dashboard and I am using Azure SQL server.  I have created one dashboard in power bi desktop using row-level security but not working properly and I am using a free trial version of power bI. row-level security needs power bi pro license? can you please help me with this?

 

 

Thank you in advance 

APIS and Embedding
Dashboards

2 Comments

  • DGTL's avatar
    DGTL
    Helper I
    4 years ago

    Hi

    For that RLS work correctly, users on the power bi service workspace must be in viewer access

    • And add the RLS to a user :
    • Right click on the dataset
    • Security
    • Assign a role with the email user 
  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    4 years ago
    Status changed:
    New
    to
    Needs Info

    Hi DB_Lad8314 

     

    Just as DGTL  said, you need to go to dataset's Security page and add users to your RLS role there, after that, make sure these users only have View permission but not Edit permission to your dataset. For more details about configuring Row Level Security and how to make it work, please refer to Row-level security (RLS) with Power BI - Power BI | Microsoft Docs.

     

    Best Regards,

    Community Support Team _Caiyun

Completed Ideas