Forum Discussion

Microsoft Employee

1 year ago

Solved

Unable to create gateway connection for SQL Server

Please help! I'm unable to create gateway connections for my SQL Server data source. However, on PBI desktop, everything works fine as usual. Once published to the service, it shows error creating t...

Need Help

Deku
1 year ago
Old solution from Microsoft https://powerbi.microsoft.com/en-us/blog/ssl-security-error-with-data-source/

And yet another one https://learn.microsoft.com/en-us/power-query/connectors/sql-server#sql-server-certificate-isnt-trusted-on-the-client-power-bi-desktop-or-on-premises-data-gateway

Deku

Super User

1 year ago

Steps suggested by Microsoft here

NothingZ

Microsoft Employee

1 year ago

Thanks a lot.

My SQL connection in PBI desktop has disabled the encryption setting before. Along with my SQL server databases have un-checked the "Encryption Enabled" options.

Still the issue persists, I'm not sure what to do next.

Forum Discussion

Unable to create gateway connection for SQL Server

Related content

Gateway connection error

Gateway Connectivity Error

Unable to see or modify users of gateway connections

gateway - unable to connect to my standard gateway

Unable to connect pipeline to Warehouse