Forum Discussion
Power BI Group Managed Service Account
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.
Thanks, that would be great.
8 Replies
I am also interested in this solution, but for a SQL server in the cloud.
I'm afraid I gave up as we couldn't find a way to get this working.
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.
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.
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.
