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

Login based visual support in power bi desktop or power bi service

Hi All,

 

I need a clarification on login based security level or row level security.

1.whether I can create a specific report which can be accessible only for that specific user login? this could be possible in Power bi desktop or in power bi service anything please guide me.

2.Manager can view all the sales person reports but an individual sales person can only view their own data,dashboard,report,how do I achieve this on power bi desktop report and in power bi service ,Some detailed steps would be helpful for me to follow.

 

final question the second scenario is possible on power bi desktop or service otherwise we need to do with dotnet appliocation.

 

badly need help on this second scenario.

 

looking forward to hearing back

 

Thanks in advance

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Login based visual support in power bi desktop or power bi service

@Charu,

You can use username() function in RLS to achieve your requirement, for more details, please review the following blog.

http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Moderator v-yuezhe-msft
Moderator

Re: Login based visual support in power bi desktop or power bi service

@Charu,

This behavior is expected, report owner will see all the data.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

13 REPLIES 13
Super User
Super User

Re: Login based visual support in power bi desktop or power bi service

Hi @Charu,

This is possible by the row level security where you can define filters and roles for different users check the link below to get started.

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

Regards,
MFelix


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

Proud to be a Datanaut!




Charu Member
Member

Re: Login based visual support in power bi desktop or power bi service

HI @MFelix

 

Thanks a lot for your response.

In that based on user login, for example, person1 logging in then only that user data he should view and if another person logging in with his/her account login their data only they could see. Is this scenario possible?

 

In power bi service how we used to log in the same way, each person will log in and we need to show their reports alone how to achieve this?

Super User
Super User

Re: Login based visual support in power bi desktop or power bi service

Hi @Charu,

 

This is based on logging in and filters you setup in the RLS in power bi desktop. Based on the several ways you setup everything it will allow user to see the information you will let them see.

 

Combining this with the APP creation you will be abble to only show the persons the reports/dashboards they need.

 

Regards,

MFelix



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

Proud to be a Datanaut!




Charu Member
Member

Re: Login based visual support in power bi desktop or power bi service

Hi @MFelix

 

Could you please elaborate about "Combining this with the APP creation you will be abble to only show the persons the reports/dashboards they need". Is this App creation is in power bi service or else dotnet apps ?

 

Please correct me If I'm wrong 

For example I have created 5reports and Manager can see all those 5reports ,coming to sales person their own reports we have to show them for that I should share their reports from my login by creating RLS?

 

 

Charu Member
Member

Re: Login based visual support in power bi desktop or power bi service

In my report, there are some 100 records from those 100 records each record belongs to one user so when the user logs in only his data he can able to see.

 

Example: Table visual --100 records 

record 1 --user1@domain.com

record 2--user2.domain.com

so and so

 

I'm an admin so I can view all the user data but when the user1 logs in he could see the only record1 vice versa.Note I want to implement this row level security in the same report I won't create 100's of reports for each user.

How could I achieve this in power bi desktop?

Please help me to get this solution.

 

Moderator v-yuezhe-msft
Moderator

Re: Login based visual support in power bi desktop or power bi service

@Charu,

You can use username() function in RLS to achieve your requirement, for more details, please review the following blog.

http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Charu Member
Member

Re: Login based visual support in power bi desktop or power bi service

Hi @v-yuezhe-msft

 

I have tried the same link which you have shared It's not working for me. don't know y!

Moderator v-yuezhe-msft
Moderator

Re: Login based visual support in power bi desktop or power bi service

@Charu,

Could you please share dummy data of your tables?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Charu Member
Member

Re: Login based visual support in power bi desktop or power bi service

For example: In my power bi desktop logged in using my account abc@domain.com, I have created some visuals and in my table data I'm having is
Table Name: SalesRep
Id Name Email
1 Sara abc@domain.com
2 Jack xyz@domain.com
Table Name: Transaction
Date SalesRep SalesAmount
2015-10-01 1 100
2015-10-02 2 500
2015-10-03 1 200

In Power bi desktop under manage roles created a role SaleRep.Email =USERNAME() then published it
When I login power bi service I could see all the data
Date SalesRep SalesAmount
2015-10-01 1 100
2015-10-02 2 500
2015-10-03 1 200
instead, I should display
Date SalesRep SalesAmount
2015-10-01 1 100
2015-10-03 1 200

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 521 members 4,150 guests
Please welcome our newest community members: