Add mail enabled security group to datasource programatically

[CaptainMouette]

Hello all,

Is there a way to programatically add a mail enbaled security group to a datasource ? I sucessfully gave ConnectionCreator rights to such a group on a gateway through the Add-DataGatewayClusterUser cmdlet, but i cannot find a way to do so at the data source level.

Unfortunately, API (https://learn.microsoft.com/fr-fr/rest/api/power-bi/gateways/add-datasource-user#datasourceuseracces...) cannot do it : "Adding groups through the API is not supported. "

So can we automate this or does it have to be manual ?

Sub-question : If the entra group is ConnectionCreator on the gateway, can it use all the datasrouces of this gateway ? Or do we need to explicitly add it at the data source level ?

Thank you for your time !

[lbendlin]

I sucessfully gave ConnectionCreator rights to such a group on a gateway through the Add-DataGatewayClusterUser cmdlet

Why would you do that? This setting is exclusively for PowerPlatform, not for Power BI. In Power BI you would use Gateways - Add Datasource User - REST API (Power BI Power BI REST APIs) | Microsoft Learn  - with the limitation you already found.

Auditing concerns aside - If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com