Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have requirement to pass user logged inn LDAP to Procedure as below.
If my LDAP is nagm then that should be passed as follows. Procedure accepts nagm or 'nagm' [meaning with or without quotes]
EXEC [DDOM_BIZOPS].[dbo].[usp_access_check_view] nagm
Placing direct LDAP is returning data as expected but our requirment is to to replace USERNAME_ [replacing with their logged inn LDAP] and run the procedure so that they can see only data that they have access to.
I tried with UPN as follows:
USERNAME_ = CONCATENATE(CONCATENATE("'",SUBSTITUTE(USERPRINCIPALNAME(),"@adobe.com","")),"'")
Then tried as follows in query and its not replacing as nagm but passing USERNAME_ as a value directly and so no data returned.
EXEC [DDOM_BIZOPS].[dbo].[usp_access_check_view] USERNAME_
Please let me know if this works in PowerBI or have to use Report Builder tool to achieve this.
This could be achieved through dynamic RLS:
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi
Thanks for the response.
We are currently using this RLS approach only and filtering data by UserPrincipleName(). It works well only if we give App access.
We have to give workspace access to Users [self-service] and if they download the PowerBI file, they can see all data.
DB wanted to handle this backend and they asked to pass user logged inn LDAP to Procedure and so like to know if we can pass UserPrincipleName() to Procedure.
We need to pass captured UserPrincipleName() to EXEC Procedure so that User can see only the data that user has eligibility.
Please let me know if any details needed.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |