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.

GilbertQ's avatar
GilbertQ
Super User
1 year ago

hi AngelG 

 

I have had a similar challenge in the past and the only way I could do it was to install and configure the On-Premise Gateway which would allow me to add in additional custom requirements for  the connection using either the SQL Server Drive or an ODBC driver with SQL Server?

  • AngelG's avatar
    AngelG
    Frequent Visitor
    1 year ago

    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.