topic Re: Couldn't connect to analysis service After Report Server version update in Report Server

Couldn't connect to analysis service After Report Server version update

JaftaT — Fri, 21 Jun 2024 08:57:44 GMT

Hi we updated the Report server to the May2024 version, and our reports that uses direct query are failing to open with the following message

The report run successfully on desktop, but fails on report server. The report is not connecting to Analysis service server, it is connecting to a database server. I checked the forum and found the following discussion. It was a bug with May2019 version, could this be a bug again or is there a workaround it?

Solved: Re: PowerBI RS May 2019 Desktop - Error Deploying ... - Microsoft Fabric Community

Re: Couldn't connect to analysis service After Report Server version update

BAP_esolutions — Fri, 21 Jun 2024 13:07:03 GMT

May 2024

Power BI Report Server

Version: 1.20.8926.40580 (build 15.0.1115.178), Released: June 10, 2024
- Bug fixes
  - Fixed issue related to Office Online Server (OOS) not working as expected.
Version: 1.20.8910.25479 (build 15.0.1115.165), Released: May 28, 2024
- Features
  - Removed AngularJS remnants
  - A recent security change requires Power BI DirectQuery reports to include "Encrypt=True;TrustServerCertificate=True" as part of the connection string on data sources or apply the "PBI_SQL_TRUSTED_SERVERS" environment variable on their Power BI Report Server machine. Read more details in the article, SQL Server certificate isn't trusted on the client.
  - Custom Visual API shipped with release - version v5.8.0
  - Various bug fixes

This solutions works:

But we dont know, how we can add more than one server to "variable value".

Re: Couldn't connect to analysis service After Report Server version update

R1k91 — Wed, 26 Jun 2024 10:37:44 GMT

to add more servers it should be enough to separate them with semicolons (;)

Re: Couldn't connect to analysis service After Report Server version update

cbernardo — Tue, 09 Jul 2024 15:37:26 GMT

Thanks for pointing this piece out!
Note: Looks like PBIRS needs to be restarted after adding the environment variable (at least it wasn't working for me until after I restarted).

Re: Couldn't connect to analysis service After Report Server version update

R1k91 — Tue, 23 Jul 2024 20:54:21 GMT

I've just tested that to add more servers/instances you need to separate them with commas (,)

Re: Couldn't connect to analysis service After Report Server version update

FatimaNASYR — Wed, 02 Oct 2024 14:24:20 GMT

To make this workaround to be effective it has to be:

setx PBI_SQL_TRUSTED_SERVERS [DDBB Server Name]

It is not enough to introduce the variable, but also include the server name.

Now it works fine!!!

source ; https://community.fabric.microsoft.com/t5/Report-Server/Issues-regarding-power-bi-report-server/m-p/3992811

Re: Couldn't connect to analysis service After Report Server version update

elprince — Wed, 09 Oct 2024 22:52:41 GMT

For me, adding servers in system variable doesn't solve the issue at all even with machine restart. but adding it as user variable for the user used to run the PBI Report Server, this solved the issue with just PBI Report Server restart without need to Machine restart and without adding servers in system variable.
Thanks for all who helped with solving this issue.