Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hai All,
I created a power bi report and i want to show the data which is related to logged in user. I gone through some of the articles. But, here the scenario is something different than others. Let say A is Table and the owner of the A table will be the Team then Team is associated with User.
If A table is having 2 members then that two members are the part of that team. At last i want to show only logged in user records in the report.
Can someone help me on this please.
Thanks in advance
Hi @Davidu ,
Dynamic Row Level Security is very suitable for your demands. Here's a sample for your reference.
This is my test table:
Click on Modeling Tab and navigate to Manage Roles icon. Then define a role name and right-click on the required table. We are going to use USERPRINCIPALNAME() in the filter condition.
This function returns the name of the user as their email address.
Now we have completed the configuration in the desktop tool. We can test the roles in the desktop itself.
Under the Modeling tab, we have an icon called View as Roles. Click on that icon, we will get a new window.
We have to select both Other user and newly created Role. Then enter the email id of one user in the text box near to the Other user text.
User will only see the records related to himself.
If you share your reports on Power BI service, you should configure the RLS in app.powerbi.com.
For detailed steps, please refer the blog:Dynamic Row Level Security (Dynamic RLS) - Microsoft Power BI Community
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply @v-yadongf-msft !
I have one issue like based on user context report is refreshing data in power bi desktop application. But, when i published in CRM, filter is not working. Can you help me on this please!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
99 | |
38 | |
37 |
User | Count |
---|---|
157 | |
120 | |
74 | |
72 | |
63 |