Forum Discussion
Issues regarding power bi report server
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.
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!!!
Hello,
I have just upgraded to the May 2024 server version and effectively all my Direct Query reports on the portal no longer work and receive the same message as you do.
So to solve the problem I followed your recommendations.
PS: I use several SQL Server where I have DB which are datasources of the reports published on the RS portal.
So I configured on the Power BI Server the env variable PBI_SQL_TRUSTED_SERVERS
Connect on server power bi with the system user declared on power bi Serve
Simply set PBI_SQL_TRUSTED_SERVERS = Server1,Server2,Server
Restart power bi and Oh magic all direct query reports work again
I expect this will help you, I've been working on this problem for 1 day.
Fabien
Thank you for the picture. We were finally able to resolve the issue by following the provided instructions.
One important point to consider is that this variable must exist in both the user variables and the system variables. However, when using the setx command to add "PBI_SQL_TRUSTED_SERVERS," it only adds it to the user variables, even if the Command Prompt is run as an administrator.
Therefore, you need to manually add the variable to the system variables to fully resolve the issue and ensure all Direct Query dashboards run correctly.
Additionally, if you are using Power BI Report Server (PBIRS), you should also set this variable in the PBIRS host.