Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

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

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 ?

1 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
 

View solution in original post

3 REPLIES 3
selimovd
Super User
Super User

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
 
Anonymous
Not applicable

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.

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
 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.