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!!!
是否有终极解决方案？
1.我尝试了添加环境变量（用户级别和系统级别），并重启RS 服务和PBI RS服务器，directquery报表仍然不工作；
2.无法在链接字符串添加加密字符串选项；（PBI desktop打开重新编辑，保留加密选项,保存到rs后没有生效，链接字符串并没有添加Encrypt=True;TrustServerCertificate=True；
尝试用postman，python，powershell强制修改这个字符串并保存，无法提交，报错401；
谁能出一个完整的教程？
我的疑问：
1.我的sql server直连数据源都是没有启用证书加密链接的；
2.数据源没有准备好的情况下，修改PBI 报告的链接字符串为启用加密选项，这样不是冲突了吗？
3.在PBI RS服务器增加环境变量，（前提是SQL SERVER启用加密证书吗）还是保持现状，不用加密证书？