topic Re: MAJ version PBIRS JAN 2025 to MAY 2025 in Report Server

MAJ version PBIRS JAN 2025 to MAY 2025

Anonymous — Thu, 21 Aug 2025 10:36:27 GMT

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,

Re: MAJ version PBIRS JAN 2025 to MAY 2025

v-pnaroju-msft — Thu, 21 Aug 2025 19:35:55 GMT

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:

Publish reports using the matching Power BI Desktop version for May 2025 Optimized for PBIRS.
Ensure that SQL/AS servers use valid TLS certificates and that the FQDN in the connection string matches the certificate.
If credentials remain invalid, restore the encryption keys via Report Server Configuration Manager: navigate to Encryption Keys and then select Restore.
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.

Re: MAJ version PBIRS JAN 2025 to MAY 2025

Shahid12523 — Fri, 22 Aug 2025 03:56:38 GMT

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.

Re: MAJ version PBIRS JAN 2025 to MAY 2025

v-pnaroju-msft — Mon, 25 Aug 2025 17:39:26 GMT

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.

Re: MAJ version PBIRS JAN 2025 to MAY 2025

v-pnaroju-msft — Thu, 28 Aug 2025 14:33:40 GMT

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.

Re: MAJ version PBIRS JAN 2025 to MAY 2025

v-pnaroju-msft — Sun, 31 Aug 2025 17:21:10 GMT

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.