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

     

     

Petebro's avatar
Petebro
Microsoft Employee
2 years ago

I'll confirm the details and update the respected docs but I think any value works (the presense of the environment var is all that it cares about). Running the command from a cmd prompt with admin rights will work:

 

setx PBI_SQL_TRUSTED_SERVERS 1

Giuseppe_Aino's avatar
Giuseppe_Aino
Advocate II
1 year ago

I read all the posts on this thread so I understood that there was a lot of confusion.

 

To summarize,

  • the problem will be resolved using the system variable PBI_SQL_TRUSTED_SERVERS (which can be easily set using SETX command from admin Command Prompt).
  • It is not clear if the environment variables must be for user or system level or even both, let's assume both.
  • The variable what will contains?
    1. Someone said to simply enter 1
    2. Someone said to simply enter the hostName of the Database server, for more than one servers separating it with a comma. Someone put the host in square brackets [], correct?
    3. At the beginning you wrote that the text "Encrypt=True;TrustServerCertificate=True" had to be inserted and how does it reconcile with the insertion of the host server?
    you did not explain it.

Opened questions:

  • In case the database service (the hostName? and if we use a DB instance?) is reached on a non-standard port, how do we use it?

 

Thank you for your patience and time

 

PS For enyone that are still asking for, it's not necessary to reboot the server machine but also restart the service.