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

3 REPLIES 3
R1k91
Skilled Sharer
Skilled Sharer

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

 

Riccardo Perico
BI & Power BI Enginner @ 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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors