topic Re: Add mail enabled security group to datasource programatically in Developer

Add mail enabled security group to datasource programatically

CaptainMouette — Thu, 03 Jul 2025 14:04:01 GMT

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#datasourceuseraccessright) 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 !

Re: Add mail enabled security group to datasource programatically

lbendlin — Thu, 03 Jul 2025 17:52:12 GMT

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

Re: Add mail enabled security group to datasource programatically

Anonymous — Mon, 07 Jul 2025 03:47:56 GMT

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

Re: Add mail enabled security group to datasource programatically

Anonymous — Thu, 10 Jul 2025 06:32:32 GMT

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

Re: Add mail enabled security group to datasource programatically

Anonymous — Tue, 15 Jul 2025 05:20:44 GMT

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