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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
New Member

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors