March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
Solved! Go to Solution.
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.
Thanks, that would be great.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
36 | |
28 | |
19 | |
10 | |
8 |
User | Count |
---|---|
54 | |
42 | |
28 | |
11 | |
11 |