Skip to main content

Power BI

Completed

Active Directory security group

Vote (35) Share
Dominic Fraser's profile image

Dominic Fraser on 22 Sep 2015 16:19:04

Manage access through Active Directory security groups. A distribution list is only helpful to a point. Active directory is already used for so many things, having the ability to manage the security to dashboards and reports would be very helpful.

Comments (11)
Dominic Fraser's profile image Profile Picture

26cc61db f8be-4b2c-8c7b-7b84d649539f on 05 Jul 2020 23:18:27

RE: Active Directory security group

Yes, this is must to have and I came across similar situation were I need to add 2000 users to access data source in data gateway cluster. These are very basic feature I don't know why Microsoft is not paying attention to these stuffs.

Dominic Fraser's profile image Profile Picture

4ef379c6 c03e-443c-8150-e73bd00593ab on 05 Jul 2020 22:49:27

RE: Active Directory security group

The thing is that I'm not aware that this is actually a documented requirement, in order to use a security group in Power BI. I believe we do not have security groups mail enabled. It's a matter of directory policy, in essence.

Dominic Fraser's profile image Profile Picture

18c59f82 95c7-4923-b196-e1d16635387a on 05 Jul 2020 22:48:36

RE: Active Directory security group

'@Rgoerwit Check out my blog on implementing AD security. It sounds like your security groups are not mail enabled. https://www.skylinetechnologies.com/Blog/Skyline-Blog/April_2017/AD_Security_for_an_On-Premises_Data_Gateway

Dominic Fraser's profile image Profile Picture

4ef379c6 c03e-443c-8150-e73bd00593ab on 05 Jul 2020 22:48:12

RE: Active Directory security group

More weirdness. When I create an app and publish it, I'm given the chance to specify who should have access to it. I find I can only specify individuals. AD security groups that have been sync'd to Azure AD for our org appear in the drop-down, and I can select and add them.

But when I go back and republish the app, and I look at the list of people and groups that have access to it, the security groups are absent!

This is exactly the behavior I was seeing (seeing comments below) with data sources. It is either an interface problem or a failure to understand what us users were actually requesting. Not sure which. Maybe both?

Dominic Fraser's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:45:39

RE: Active Directory security group

Unable to add active directory groups to workspaces, can do so for content packs etc. Is this going to be included?

Dominic Fraser's profile image Profile Picture

f0ab1e3e a4f2-4db2-80dc-aecc2c2e1422 on 05 Jul 2020 22:44:37

RE: Active Directory security group

It seems that I can add users via an AD Security or distribution list, but the individual users are not receiving any e-mail...Am I missing something?

Dominic Fraser's profile image Profile Picture

a870d0f4 38a8-44f5-8db8-5265159c16d8 on 05 Jul 2020 22:42:53

RE: Active Directory security group

Can someone provide details on how to leverage that. In Desktop I see there is an active directory source I can connect to, and then I see a hundred tables that I could probably leverage to get the user/group association. But I'm not familiar with AD so I don't know where to start

Dominic Fraser's profile image Profile Picture

10c7363f d5e6-476b-9bfe-b474d55b765c on 05 Jul 2020 22:34:46

RE: Active Directory security group

Is this really implemented? Seems like everywhere I read, the gateway connector to on-premise services (and other data) is using a "single user" for access stored in the power bi portal. All other users in the organization then connect through this single user. People say "do Row Level Security" or "Use Power BI groups". As rgoerwil mentions, it leaves us the choice of double management.

Dominic Fraser's profile image Profile Picture

4ef379c6 c03e-443c-8150-e73bd00593ab on 05 Jul 2020 22:28:26

RE: Active Directory security group

Is this really done? All I can see is that access to a data source can be granted to an AD security group. The more pressing issue, though, is that we need a way to grant an AD security group access to a report.

Otherwise, we end up recreating (and hand maintaining) groups that exist already in our organizational AD trees.

I work at a college and I may want to share a report with all faculty. Believe me, I don't want to have to hand maintain a list of faculty in Power BI/Office 365, especially when our AD DCs already know who faculty are!

Dominic Fraser's profile image Profile Picture

1c9a922a 5ab0-4382-b158-8d2da93f1ee4 on 05 Jul 2020 22:12:16

RE: Active Directory security group

great enterprise feature. Does this works for 60 day trail license pro users