cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Akshaya Established Member
Established Member

Row LEVEL Security

Hey,

 

I am changing from Qlikview to Power BI. I have a table in ODS that has a list of User ID's and the Region data that they have access to. So in Qlik , this table is loaded as Section Access and on the front end, I have an option to click "Section Access" which automatically enables those people to view the application only for the regions that they are assigned to.

 

I want to be able to do something similar in POWERBI. I will be loading that table and connectinf it to the Region table based on "Manage relationship" between table. I want to know what is the next step after this for RLS?

 

I tried doing a manual RLS by "Manage Roles". But this works only when members have read only mo!e and hence cannot pin report views to dashboard. Moreover, this manual entry wont work if a person switches to another region in the course of his employment.

 

Is there any way this can be achieved? Thank You!

1 REPLY 1
Super User IV
Super User IV

Re: Row LEVEL Security

So, this is done differently in Power BI. In Power BI you would create an RLS role for each Region. Then, in the Service, you assign users to roles. If a user pins a dashboard tile and then changes roles, I believe they will get a blank tile. If a user changes regions, just go into the Service and move their role.

 

Essentially, you can discard the user from your table, it is meaningless.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors