March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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 ?
Solved! Go to 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
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
91 | |
88 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
73 | |
68 |