MAJ version PBIRS JAN 2025 to MAY 2025

[Anonymous]

Dear All,

after migrate PBIRS version Jan 2025 to May 2025, i have an issue on the connection strings of PBI reports (encrypted caracters) and i can't publish new PBI reports with connection string and schedule. I precise the issue don't happen on data sources of RDL reports.

Can we help me ?

Best regards,

[v-pnaroju-msft]

Hi Samuelhvgf,

We wanted to see if the information we gave helped fix your problem. If you need more help, please feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi Samuelhvgf,

We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi Samuelhvgf,

We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

[Shahid12523]

After upgrading PBIRS from Jan 2025 to May 2025, encrypted connection strings in Power BI reports may break publishing and scheduling. RDL reports are unaffected.

How to Fix:

Set this environment variable on the server:
PBIRS_EnableLegacyConnectionStringHandling = True
Then restart the PBIRS service.

[v-pnaroju-msft · Accepted solution]

Hi Samuelhvgf,

We appreciate your inquiry submitted through the Microsoft Fabric Community Forum.

Based on my understanding, the May 2025 PBIRS release introduced stricter security enforcement for Power BI report connections. SQL and Analysis Services servers must now be explicitly trusted (PBI_SQL_TRUSTED_SERVERS) and present a valid TLS certificate. This change explains why PBIX reports fail while RDL reports, which use a different credential handling mechanism, continue to function. In some instances, if encryption keys were not restored correctly or if the PBIRS service account was changed during the upgrade, stored credentials may also become invalid.

Please follow the steps below, which may help to resolve the issue:

1. Publish reports using the matching Power BI Desktop version for May 2025 Optimized for PBIRS.
2. Ensure that SQL/AS servers use valid TLS certificates and that the FQDN in the connection string matches the certificate.
3. If credentials remain invalid, restore the encryption keys via Report Server Configuration Manager: navigate to Encryption Keys and then select Restore.
4. In the PBIRS portal, go to Manage and next to Data Sources, re-enter the stored credentials, and test the connection.

For additional information, please refer to the following documentation:
Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn

We hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

Thank you.