Forum Discussion

PranavC's avatar
PranavC
New Member
8 months ago
Solved

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).MSRep...
"Power BI Report Server “
  • v-ssriganesh's avatar
    v-ssriganesh
    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.

v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
8 months ago

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.