Forum Discussion
Solved
Power BI cannot connect to SQL Server
I can connect to SQL Server from Tableau (Direct Query) without issues, but Power BI fails with errors like “error: 40 - Could not open a connection to SQL Server” or “Connection Timeout / pre-login ...
Hi prabavathym
This happens because Tableau uses its own ODBC drivers, while Power BI depends on Microsoft SQL drivers. Fix is usually:
- Install the latest MSOLEDBSQL driver.
- In Power BI connection >> Advanced options, test with Encrypt/Trust server certificate on/off.
- Use SERVER,PORT instead of SERVER\INSTANCE.
- Ensure TCP/IP remote connections are enabled in SQL Server.
Hi prabavathym
I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.
Thank You.