Embed PBI in Sharepoint & make viewable only to SP user viewing

[Anonymous]

I'm building a PBI Report (using PBI Premium) and want to embed it to my sharepoint site.   The report will have parameter for an employee but I want the report data to only be viewable to the employee's data whos viewing it on the site.   How do I tie the employee parameter to sharepoint current viewer ?

[selimovd]

Hey @Anonymous ,

as Sharepoint is also part of Office365 it won't change much for you.

You can check the current user in the report with the function USERPRINCIPALNAME() and then use Row Level Security to only show the information he is allowed to see.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Thanks  @selimovd   this is helpful.   Question - can you use this function more than once?  For example, if the manager is viewing PBI,  it will display all their employees.

[selimovd · Accepted solution]

Hey @Anonymous ,

actually you do it the other way around, you check who is the user that is viewing the report with USERPRINCIPLENAME and then either show everything or just specific content. Check the following article on how to do that:

Dynamic Row Level Security with Profiles and Users in Power BI : Many-to-Many Relationship - RADACAD

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic