Forum Discussion
Unable to configure Report server configuration manager with script/ code
- 8 months ago
Hello PranavC,
You’re correct in your observation.
Cmdlets such as Set-RsEmailSettings, Set-RsDatabase, and Set-RsDatabaseCredentials in the ReportingServicesTools module are SSRS-specific and are not supported for PBIRS. These commands rely on WMI/APIs that are intentionally not exposed in PBIRS, so they may work for SSRS but will fail or behave inconsistently when used with PBIRS.For PBIRS, there is no supported API, WMI interface or PowerShell method to configure database connections, email settings, service accounts, or encryption key restore. Manual configuration via the Report Server Configuration Manager UI is the only supported and reliable approach today. Limited scripting support exists only for URL/SSL bindings and encryption key backup. This behavior is by design, not related to permissions or version issues.
Thank you for your patience.
Hello v-ssriganesh ,
I have reviewed the ReportingServicesTools PowerShell module (Install-Module -Name ReportingServicesTools) from microsoft/ReportingServicesTools: Reporting Services Powershell Tools. I noticed that while some methods work as expected, others appear to be SSRS-specific and do not work with PBIRS, such as:
Set-RsEmailSettings
Set-RsDatabase
Set-RsDatabaseCredentials
Could you please confirm if these methods are supported for PBIRS, or advise on the recommended approach to configure these settings for PBIRS?
Hello PranavC,
You’re correct in your observation.
Cmdlets such as Set-RsEmailSettings, Set-RsDatabase, and Set-RsDatabaseCredentials in the ReportingServicesTools module are SSRS-specific and are not supported for PBIRS. These commands rely on WMI/APIs that are intentionally not exposed in PBIRS, so they may work for SSRS but will fail or behave inconsistently when used with PBIRS.
For PBIRS, there is no supported API, WMI interface or PowerShell method to configure database connections, email settings, service accounts, or encryption key restore. Manual configuration via the Report Server Configuration Manager UI is the only supported and reliable approach today. Limited scripting support exists only for URL/SSL bindings and encryption key backup. This behavior is by design, not related to permissions or version issues.
Thank you for your patience.
- PranavC8 months agoNew Member
Thanks for your help.