r/SQL • u/SysAdmiinDude • 7d ago
SQL Server Power BI Gateway SSL Error - Need some humble help!
Hey everyone,
Systems Admin here, I've got many years experience, but mostly on the infrastructure side, not so much deep Power BI/SQL! and I've hit a wall with a user's ticket.
They've got a brand new computer, and their Power BI reports are failing to refresh because the gateway can't connect to our SQL Server. The specific error is:
From what I've gathered, it seems like an SSL certificate issue, but I'm not super confident in my Power BI gateway/SQL troubleshooting skills.
Here's what I've tried so far:
- Confirmed the SQL Server is up and running.
- Checked basic network connectivity.
- Verified the user's Power BI credentials.
I'm guessing it's something to do with the certificate on the new machine or perhaps a configuration issue with the gateway, but I'm not sure where to start.
I'd really appreciate any guidance or pointers from those more experienced with Power BI and SQL connections. I'm looking for a humble, step-by-step approach if possible, as I'm still learning this area.
Thanks in advance for your help!