Forum Discussion
Unable to configure Report server configuration manager with script/ code
Hello everyone,
Previously, we were using SSRS for reporting, and to configure it using the WMI methods:
Get-WmiObject -Namespace and the configuration members (as documented by Microsoft).MSReportServer_ConfigurationSetting members - SQL Server Reporting Services (SSRS) | Microsoft Learn
We are now in the process of moving to PBIRS and would like to know if there are any official knowledge articles or supported methods available to configure PBIRS to configure the Report Server Configuration Manager.
We are currently facing issues while configuring PBIRS because the WMI methods exposed for SSRS do not seem to work for PBIRS.
Could you please help? Are there any supported methods or APIs available to configure PBIRS?
The table below is used to configure SSRS or PBIRS.
Report Server Configuration Manager | SSRS | PBIRS |
Service Account | SetVirtualDirectory | Methods not working/Methods not available for PBIRS configure |
Web Service URL | ReserveURL , CreateSSLCertificateBinding , RemoveURL , RemoveSSLCertificateBindings | ReserveURL , CreateSSLCertificateBinding , RemoveURL , RemoveSSLCertificateBindings |
Web Portal URL | ReserveURL , CreateSSLCertificateBinding , RemoveURL , RemoveSSLCertificateBindings | ReserveURL , CreateSSLCertificateBinding , RemoveURL , RemoveSSLCertificateBindings |
Database | GenerateDatabaseCreationScript , SetDatabaseConnection | Methods not working/Methods not available for PBIRS configure |
Email Settings | Set-RsEmailSettingsAsNoAuth | Methods not working/Methods not available for PBIRS configure |
Encryption Key - Backup | .\RSKeyMgmt.exe -e -f | .\RSKeyMgmt.exe -e -f |
Encryption Key - Restore | .\RSKeyMgmt.exe -a -i | Methods not working/Methods not available for PBIRS configure |
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.
5 Replies
Hello PranavC,
Thank you for posting your query in the Microsoft Fabric Community Forum.
For Power BI Report Server (PBIRS), the recommended and most reliable way to configure it programmatically including URLs, SSL bindings, database connections, email settings, and encryption keys is to use the official Microsoft ReportingServicesTools PowerShell module.This module is maintained by Microsoft, fully supports PBIRS, and provides simple, high-level commands for all the tasks you're trying to automate. It avoids the WMI namespace issues commonly seen when migrating from SSRS. You can install it easily from the PowerShell Gallery with Install-Module -Name ReportingServicesTools.
The Report Server Configuration Manager UI is still the primary method, but this PowerShell module is the supported scripting approach for automation in PBIRS.
Best regards,
Ganesh Singamshetty.Hello PranavC,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
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.
