Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Can anyone please help me? This is really urgent issue.
Appreciate your time in advance. Looking forward for the solution.
Solved! Go to Solution.
For users D, E, and F you would make a role that has no filters in it and add them to that. The users just have to be a member of a role and the role determines the filters. If there are no filters in the role they can see all the data.
Did you add them to the role in the power bi service?
https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls#add-members
@jdbuchanan71 - Thanks for your reply. I found this - https://www.sqlbi.com/blog/marco/2021/06/03/setting-the-right-permissions-for-users-of-composite-mod... , it seem I have to give them 'Build' permissin. And it worked perfectly fine.
For users D, E, and F you would make a role that has no filters in it and add them to that. The users just have to be a member of a role and the role determines the filters. If there are no filters in the role they can see all the data.
Hi @jdbuchanan71 - This is something new. I have provided RLS to my data and did test as a role. But end user are not able to see the data.
@jdbuchanan71 - Thank you so much. It's already 10pm now. I have created a a new role but didn't any filter on it. I will check with my colleague tomorrow if they can able to see the data now. Basically will check with User D, E and F 🙂
Really appreciate your help!
Does your model have row level security enabled? If so, you also have to add the users to the role that lets them see data. If you make them members of the workspace RLS is not applied but if you share the report with them RLS is applied.
https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls#add-members
@jdbuchanan71 - Hi there, I just want to make sure I understand correctly.
I do have RLS applied to this report for specific users; let say User A, User B, and User C for specific regions.
User A for East region
User B for Central region
User C for West region
Also, I do have User D, User E , User F. I don't want to provide any RLS level security for them. They can see all three regions data; Are you saying I have to add their email id to each RLS?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |