Forum Discussion

NothingZ's avatar
NothingZ
Icon for Microsoft Employee rankMicrosoft 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's avatar
Deku
Icon for Super User rankSuper User
1 year ago

Steps suggested by Microsoft here

NothingZ's avatar
NothingZ
Icon for Microsoft Employee rankMicrosoft 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.