Forum Discussion

AngelG's avatar
AngelG
Frequent Visitor
1 year ago
Solved

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 authenticati...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

AngelG's avatar
AngelG
Frequent Visitor
1 year ago

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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.