Forum Discussion
Power BI Service cloud Connection with TrustServerCertificate=True
Hi,
I need to setup a refresh schedule with a sql datasource in the cloud but I am having issues setting up the cloud connection. I am able to set the server name, database name, basic authentication with user name and password and the connection is set to encryted. But our vendor require us to set "TrustServerCertificate=True" which is not an option when setting up the connection. I tried adding the TrustServerCertificate=True to the end of the database name (tried both , and ; and True and Yes combo to no avail).
How do you set this option on a service cloud connection in Power BI service?
Thanks.
Hi, AngelG
You can check out the following solution to apply the server to connect to your SQL Server in port mode. This server connection string also applies to Power BI service.
Solved: sql - Microsoft Fabric Community
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi GilbertQ,
Had not thought about your solution but it make sense. I was able to create a connection thru a gateway using the OLE DB connection type. But have not been able to associate my PBI app to this connection. Do I also change the connection type in my PBI to OLE DB instead of what I am using now, SqlServer? Thanks.
Your solution is so great GilbertQ
Hi, AngelG
As Super User said, you need to install the enterprise gateway, and then configure it in your gateway computer, as follows:
Power Query SQL Server connector - Power Query | Microsoft Learn
Configure SQL Server Database Engine for encryption - SQL Server | Microsoft Learn
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jianpeng,
Thanks for the feedback. I saw the article you referenced and we went that route but ran into a problem. Our vendor requires us to specify a port number in the connection like mysvr.microsoft.com,12345 but the article mentions that the values are in a comma-delimited list so it's looking for "mysvr.microsoft.com" or "12345". Do you know if qoutes are acceptable when listing servers with port numbers? Thanks.
Hi, AngelG
You can check out the following solution to apply the server to connect to your SQL Server in port mode. This server connection string also applies to Power BI service.
Solved: sql - Microsoft Fabric Community
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
