Power BI Group Managed Service Account

[PeterMansion]

We're building a Power BI report that uses data store on an on-premises SQL server.

We've create a Group Managed Service Account for the SQL connection.

When we configure the connection in Power BI we can input the new gMSA username e.g. ZZ\xxxx_xxxx_xxxx$ however because it's a gMSA we don't have a password to enter . Consequently, the 'Create' button remains greyed out preventing us from creating the connection.

Any thoughts?

Many thanks in advance.

[mdarlinghammond]

I am also interested in this solution, but for a SQL server in the cloud. 

[PeterMansion]

I'm afraid I gave up as we couldn't find a way to get this working.

[mdarlinghammond]

Okay, I am working internally in my company to see if we can find anything. If we do, Ill reply here and let you know.

[PeterMansion · Accepted solution]

Thanks, that would be great.

[v-zhangti]

Hi, @PeterMansion 

Please refer to the following links in the hopes of helping you.

Step-by-Step: How to work with Group Managed Service Accounts (gMSA) (microsoft.com)

Getting Started with Group Managed Service Accounts | Microsoft Learn

Re: Is running the PBI Report Server with a gMSA s... - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PeterMansion]

Hi, thanks for the links but I'm afraid they don't help. 

We've managed to create the gMSA (which is the topic for the forst two links). 

The third link gives guidance on using a gMSA for running the Gateway on a server which is different to using a gMSA for a SQL connection.