Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello ,
I have scenario that created dynamic RLS and it is working in desktop then move to PBI service and published the report to App. Now i have a user who is part of dynamic RLS coming from database table but unable to view report content but the same user can see data after adding that user id into role under security of power bi dataset in power bi service. do we need to setup users though we have set it up in DB table? I do have 100's of users and looking for better solution.
Thanks,
Sreenivas Amirineni
This is not premium workspace and i am using pro license for workspace. But i am not seeing the way to impliment Dynamic RLS other than adding users (i did add AD group to Role created in dataset in power BI service).
However, that is how it is working for me.
the question was not about to add them to workspace or workspace app. Its more about adding users to role under dataset ->secuirity. do we need to add users into role after published the dataset into power BI service.
Can we avoid this step since users are supplied from database table and we use userprincipalname() function to determine.
Its more about adding users to role under dataset ->secuirity. do we need to add users into role after published the dataset into power BI service.
No, never. Especially not with dynamic RLS. But it's generally a VBI.
However the solution that i did enable works only after adding them into role under dataset located in power bi service. otherwise they wont work. i am using PRO license and publish the workspace app for users.
You should exclusively share the app through the audiences. Do not share anything from the workspace to any user who is not a developer or UAT tester.
If this is a premium capacity workspace you need to add the user to one of the app audiences and update the app.
Don't add them to the workspace unless they are a UAT participant or the workspace is non-premuim.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
30 | |
18 | |
12 | |
8 |
User | Count |
---|---|
50 | |
36 | |
30 | |
15 | |
12 |