Forum Discussion
Couldn't connect to analysis service After Report Server version update
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
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.
- Bug fixes
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
- Features
This solutions works:
But we dont know, how we can add more than one server to "variable value".
6 Replies
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.
- Bug fixes
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
- Features
This solutions works:
But we dont know, how we can add more than one server to "variable value".
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).
to add more servers it should be enough to separate them with semicolons (;)
I've just tested that to add more servers/instances you need to separate them with commas (,)
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!!!
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.
