Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
ryatatu
Frequent Visitor

how to automate changing password for gMSA user account for Report Server SQL DataSource

Dear PBI experts,

 

Pls provide advice

 

I faced following situation:

for my PBIX file SQL Database used as DataSource

i need to organize process of refresh data model by means of using gMSA windows domain account.

 

When i put gMSA account into User name Report Server asks me for gMSA password, but as username is gMSA,

i expect password for gMSA to be provided automatically. 

 

should i use some Power Shell script for this task to  change gMSA password automatically?

or there are some alternatives ways you may recommend to change password automatically without need of manual password changing ? 

 

ryatatu_1-1638871530812.png

 

Bst rgrds, 

Alexsandr 

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @ryatatu ,

 

Try the following command in powershell.

 

New-ADServiceAccount [-Name] <string> -RestrictToOutboundAuthenticationOnly [-ManagedPasswordIntervalInDays <Nullable[Int32]>] [-PrincipalsAllowedToRetrieveManagedPassword <ADPrincipal[]>]

 

vhenrykmstf_0-1639105169193.png

 

Also, you can refer to the following blog as below.

https://blog.wicktech.net/powershell-install-gmsa/


If the problem is still not resolved, please point it out and provide related operation screenshoots. Looking forward to your reply.


Best Regards,
Henry


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

View solution in original post

4 REPLIES 4
v-henryk-mstf
Community Support
Community Support

Hi @ryatatu ,

 

Try the following command in powershell.

 

New-ADServiceAccount [-Name] <string> -RestrictToOutboundAuthenticationOnly [-ManagedPasswordIntervalInDays <Nullable[Int32]>] [-PrincipalsAllowedToRetrieveManagedPassword <ADPrincipal[]>]

 

vhenrykmstf_0-1639105169193.png

 

Also, you can refer to the following blog as below.

https://blog.wicktech.net/powershell-install-gmsa/


If the problem is still not resolved, please point it out and provide related operation screenshoots. Looking forward to your reply.


Best Regards,
Henry


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

Anonymous
Not applicable

I think this has to be a manual process, but would suggest trying out with power automate once.

we consider it has no sense for us to change password manually, instead try to find some way to get passsword from AD and change it automatically by means of PS script, as described in this link: 

 

https://stackoverflow.com/questions/60165643/set-report-data-source-and-credentials-on-power-bi-repo...

did anybody have experience of getting gMSA password directly from AD by means of PS script ? 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.