Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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 

Status: 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

Comments
DGTL
Helper I

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
Community Support
Status changed 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