Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Community,
I am trying to build RLS through AD security group, I can easily add that group in RLS security in Power bi Service. So i am trying to get Group name,Display name and User Principle Name from AD.
Can anyone guide me how can i get group name from AD. All I can see Display name and User Principle Name.
When i click on groups , it shows Nulls.
Followed steps.
Can anyone guide me to get Group name also. So i can easily assign that in Service instead of adding all users in RLS security.
Thanks!
Solved! Go to Solution.
hi @cv2qm
You may load "group" table into power bi, please refer to this blog:
https://matt40k.uk/2016/06/getting-a-list-of-ad-groups-and-their-members-using-powerquery/
Regards,
Lin
hi @cv2qm
You may load "group" table into power bi, please refer to this blog:
https://matt40k.uk/2016/06/getting-a-list-of-ad-groups-and-their-members-using-powerquery/
Regards,
Lin
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |