Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
JaftaT
Regular Visitor

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 

JaftaT_0-1718959891796.png

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

1 ACCEPTED SOLUTION
BAP_esolutions
New Member

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:

BAP_esolutions_0-1718975037899.png

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

View solution in original post

6 REPLIES 6
elprince
Regular Visitor

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.

FatimaNASYR
New Member

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/...

R1k91
Solution Supplier
Solution Supplier

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

 


--
Riccardo Perico
BI & Power BI Engineer @ Lucient Italia

Blog | GitHub

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
R1k91
Solution Supplier
Solution Supplier

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


--
Riccardo Perico
BI & Power BI Engineer @ Lucient Italia

Blog | GitHub

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BAP_esolutions
New Member

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:

BAP_esolutions_0-1718975037899.png

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).

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.