79431472

Date: 2025-02-11 22:35:23
Score: 3.5
Natty:
Report link

This is resolved. Apparently this is a Microsoft limitation where the SQL Server certificate is not trusted with On-Premises Data Gateways: https://learn.microsoft.com/en-us/power-query/connectors/sql-server#limitations

I added my server to the "SqlTrustedServers" configuration in the Gateway config file and it resolved my issue. Gateway Config

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • No code block (0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Ben Schmalz