How to create Row Level Security in Database side

[Anonymous]

HI I am using Azure Sql server databse

My sql server version:2014

please any explain how to create Row level security in database 

after creating RLS in database how to use in Power BI desktop(mean we create user account in Power BI)

[v-yuta-msft · Accepted solution]

@Anonymous ,

I haven't found any doc which clarify that Azure SQL Server supports RLS. But now SQL Server 2019(on-premises) supports RLS feature, please read doc below:

https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15

In addtion, if you need to configure RLS for your tables, you can import the Azure SQL Server data to Azure SQL Data Warehouse and configure RLS using Azure Data Warehouse.

https://azure.microsoft.com/en-us/updates/general-availability-row-level-security-rls-for-microsoft-azure-sql-data-warehouse/

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.