cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sid1582 Visitor
Visitor

Power BI embedded - data security based on user role

Team - 

 

We have a HRMS system and we want to use PowerBI embedded for showing BI outputs. As a result , this involves limiting the data to a user and showing the user his own data and managers the data of their reportees. 

 

An access matrix system is already implemented in the HRMS. We want to implement a similar access stack with the Power BI. Is there a way to do it ? Please advise.

 

Roles -

Analyst group - sees their own data 

Manager group - see their reportees data 

Vertical leads - sees all data under a vertical 

All - See all data 

 

Kindly advise.

 

Regards,

Siddharth

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-ljerr-msft Super Contributor
Super Contributor

Re: Power BI embedded - data security based on user role

Hi @sid1582,

 

Row level security (RLS) can be used to restrict user access to data within dashboards, tiles, reports, and datasets. Multiple, different users can work with those same artifacts all while seeing different data. Embedding supports RLS. Smiley Happy

 

If you're embedding for non-Power BI users (app owns data), which is typically an ISV scenario, then this article is for you! You will need to configure the embed token to account for the user and role.

 

If you are embedding to Power BI users (user owns data), within your organization, RLS works the same as it does within the Power BI service directly. There is nothing more you need to do in your application. For more information see, Row-Level security (RLS) with Power BI.

 

Regards

View solution in original post

1 REPLY 1
Highlighted
v-ljerr-msft Super Contributor
Super Contributor

Re: Power BI embedded - data security based on user role

Hi @sid1582,

 

Row level security (RLS) can be used to restrict user access to data within dashboards, tiles, reports, and datasets. Multiple, different users can work with those same artifacts all while seeing different data. Embedding supports RLS. Smiley Happy

 

If you're embedding for non-Power BI users (app owns data), which is typically an ISV scenario, then this article is for you! You will need to configure the embed token to account for the user and role.

 

If you are embedding to Power BI users (user owns data), within your organization, RLS works the same as it does within the Power BI service directly. There is nothing more you need to do in your application. For more information see, Row-Level security (RLS) with Power BI.

 

Regards

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 366 members 3,377 guests
Please welcome our newest community members: