Row Level Security - Step by Step Process

[Anonymous]

Hi Experts,

Just wondering if you could please help me direct to any online resources which demostrate the step by step process of implementing the row level security using the SQL Server database tables, particularly users table.

I am looking at filtering the data based on the user geographical area level access with geographical heirarchy, like sector, division and zone etc.

Appreciate any inputs.

[v-luwang-msft]

Hi @Anonymous ,

About Rls ,You can see the official article， it tells:

You can configure RLS for data models imported into Power BI with Power BI Desktop. You can also configure RLS on datasets that are using DirectQuery, such as SQL Server. For Analysis Services or Azure Analysis Services lives connections, you configure Row-level security in the model, not in Power BI Desktop. The security option will not show up for live connection datasets.

So, in my opinion, it makes no difference if the data source is in sql or in excel, import, direct can also be configured with rls. And the step by step process , the  official article link I shared with it,you could refer.

And about RLS With Hierarchies ,you could refer the following vidio(it with detail operation):

https://www.youtube.com/watch?v=oPwDkgPU9uc 

And I find another case about   RLS With Hierarchies, you could refer it:

https://community.powerbi.com/t5/Desktop/RLS-Hierarchy-TEXT/m-p/2011273  

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Anonymous]

Hi @v-luwang-msft 

Thank you very much for your reply. Appreciate it.

However, the links you shared shows the examples around the staff hierarchy with the staff and their managers.

My scenario is based on the Geographical hierarchy. Below is the structure of my user table I have.

The highest level in the hierarchy is Divsion and then Sector and then zone and then lowest is station.

In the below example, staff S123 should have access to only one station (Station1) under Sector1.

Then everything under sector Sector2 and everything under Division2.

Appreciate if there is an example with this scenario.

Appreciate any help here.

Station	Zone	Sector	Division	Email	StaffID
Station1	Zone1	Sector1	Dvision1	staff1@company.com	S123
*	*	Sector2	Division1	staff1@company.com	S123
*	*	*	Division2	staff1@company.com	S123