Forum Discussion

extol7's avatar
extol7
New Member
1 year ago
Solved

Error creating Power BI Data Gateway connection

I am trying to create a Gateway connection to a Production SQL server VM in Azure.  We have similar connections working fine, and firewall settings are fine, but we are getting this error:   The SQ...
Need Help
  • extol7's avatar
    extol7
    1 year ago

    Thank you lbendlin  and Anonymous , the resolution was that I needed to an an SSL Certficate to the Cert Store on the SQL server in Azure, than in SQL configuration manager > add the certificate.  After that, We were able to sucessfully create a Data Gateway in Power BI Admin Center.  

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Check with the SQL server admins. Sometimes production servers have encryption disabled for performance reasons.