Forum Discussion

flem81's avatar
flem81
Frequent Visitor
2 years ago
Solved

Issues regarding power bi report server

Hi We have two issues regarding power bi report server. 1st. After updating to the latest version (Maj update), our reports using direct query does not work. Error messages “we could not conn...
Paginated Report
Power BI Report Server
Sunburst
  • Petebro's avatar
    Petebro
    2 years ago

    Apologies for this change not being mentioned....I forgot to add this to the changelog and release notes (and will be fixing that today).

     

    The May release has a expected change on the AS side of things which will require customer actions to keep some existing scenarios working. As part of a push for security customers will have to explictly include “Encrypt=True;TrustServerCertificate=True” as part of the connection string or apply the “PBI_SQL_TRUSTED_SERVERS” environment variable to their server to Power BI Report Server machine.

  • ManuelEscanez's avatar
    ManuelEscanez
    2 years ago

    Good afternoon,

     

    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!!!

     

     

ManuelEscanez's avatar
ManuelEscanez
Helper I
2 years ago

Good morning,

I am having the same issue with directQuery models.

 

Some of them are showing that "we could not conect to Analisys Services"

 

Those reports with a landing page show more detail about the error:

 

"A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - La cadena de certificación fue emitida por una entidad en la que no se confía.);La cadena de certificación fue emitida por una entidad en la que no se confía. La interfaz de IDbConnection ha producidola excepción."
 
Any idea how to solve the issue????
 

 

 

 

ManuelEscanez's avatar
ManuelEscanez
Helper I
2 years ago

Going deeper on the problem, it looks that the SERVER SIDE of PBRS is trying to stablish an encrypted connection with the SQLServer which is not configured to work like this.

 

The Directquery reports work fine in PbiDesktop but, when uploaded on the server they won´t load.

 

This issue has been created 100% by the May 2024 update of the PBIRS.

 

It was working fine til last night when I updated the server....