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 !

[Anonymous]

Hi @CaptainMouette,

Just following up to see if the solutions provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[Anonymous]

Hi @CaptainMouette,

Just checking in were you able to post your suggestion in the Ideas Forum as recommended?

Also, if your issue has been resolved in the meantime, we’d really appreciate it if you could share the solution here. It could be helpful for others facing similar challenges.

Warm regards,
Prasanna Kumar

[Anonymous]

Hi @CaptainMouette,

Thank you for reaching out to the Microsoft Fabric Forum Community, and thanks to @lbendlin  for the quick and helpful response.

You're absolutely right the API currently doesn’t support adding Entra ID groups directly to data sources. As @lbendlin  suggested, if this feature is important to you, please consider voting for an existing idea or submitting a new one using the link provided.

Thanks & Regards,

Prasanna Kumar

[lbendlin · Accepted solution]

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