Is running the PBI Report Server with a gMSA supported?
I currently have a Power BI Report Server running with a domain account and using kerberos to access other SQL Servers and SSAS. I'm now trying a new install using a gMSA (group managed service account) as the Service Account running the PBIRS. I have verified that the SPNs and delegations correspond to our running servers and they "look" correct. However, whenever I try to access a report using Windows Auth for the data source, we get the dreaded "We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly." Is this a supported scenario, PBIRS using gMSA and kerberos to connect to other SQL Servers? In the documentation at Configure the Report Server Service Account (Configuration Manager) - SQL Server Reporting Services (SSRS) | Microsoft Docs (which is referenced from Install Power BI Report Server - Power BI | Microsoft Docs), it does not specifically call out gMSA as an option for the Service Account. Are others running in this scenario? Any tips, suggested documentation, etc? Thanks so very much for any pointers/advice! This wasn't easy the first 2 times and continues to be a challenge. 🤔 janice
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 ? Bst rgrds, Alexsandr
