Forum Discussion
NothingZ
Microsoft Employee
1 year agoUnable 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...
NothingZ
Microsoft Employee
1 year agoThank you for your infomation. I have tried following steps and adding entries on SqlTrustedServers field in gateway config file, but still it would not allow me to create such SQL Server on-premise gateway connection😓.
Another thing I tried: OLE DB connection type works fine in gateway new connection creation as it provides "TrustServerCertificate=True" in connection string. However, OLE DB data souce from PBI desktop once published to the service, it becomes SQL Server connection type again and be un-able to add such parameter in the connection.
Deku
Super User
1 year agoThink it might be time for a support ticket