High severitygateway
Power BI Refresh Error:
OLE DB or ODBC error
What does this error mean?
The ODBC or OLE DB driver used to connect to the data source returned an error. This is common with on-premises databases accessed through drivers installed on the gateway machine.
Common causes
- 1The ODBC or OLE DB driver on the gateway machine is outdated or incompatible with the data source version
- 2The DSN (Data Source Name) configured for an ODBC connection is incorrect or missing
- 3The driver was not installed for the same bitness (32-bit vs 64-bit) as the gateway service
- 4A driver-level authentication failure when using Windows integrated security (Kerberos/NTLM)
- 5The ODBC/OLE DB driver returned a SQL error code — check the inner error for the specific SQL state
How to fix it
- 1Check the full error message for a SQL State code (e.g., 28000 for auth, 42000 for syntax) — it points to the root cause
- 2Update the ODBC or OLE DB driver on the gateway machine to the latest version that supports your database
- 3Ensure the driver is installed as 64-bit — the gateway service runs in 64-bit mode
- 4If using DSN-based connections, verify the DSN is configured at the system level (not user level) in ODBC Data Source Administrator
- 5For Kerberos failures, use the Kerberos Configuration Manager tool to diagnose SPN and delegation issues
- 6Test the ODBC connection using the 'Test Connection' button in ODBC Data Source Administrator on the gateway machine