Splunk ODBC Connection Failure: Error response received from the server: [ERROR]: Login failed

Available Languages

Updated:September 29, 2026
Document ID:SPLK048500

Bias-Free Language

The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.

Applicability

Splunk Cloud

Description

During the Splunk ODBC connection process for Microsoft Power BI, the ODBC Driver window will request the username and password for the Splunk Instance and user then must click on Connect, afterwards Microsoft will connect to the Splunk platform:

 

 

During this process, the following error is returned and setup is unable to complete:

DataSource.Error: ODBC: ERROR [HY000] [Splunk][SplunkODBC] (70) Error response received from the server: [ERROR]: Login failed
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=Splunk ODBC
OdbcErrors=[Table]

Investigation

The following SPL search was used to verify the user used to establish the ODBC connection, it can be seen Splunk received the connection call.

Search:

index=_internal sourcetype=splunkd_access *splunk-odbc*

Result:

1xx.1xx.1xx.1xx - - [30/Jan/2025:15:19:56.578 +0000] "POST /servicesNS/username@email.com/search/telemetry-metric HTTP/1.1" 500 130 "-" "splunk-odbc/3.1.1" - - - 8ms

 

When looked at the audit logs, it can be seen the login attempt has failed.

Search:

index=_audit sourcetype=audittrail "action=login attempt" username@email.com

Result:

01-30-2025 15:19:56.574 +0000 INFO  AuditLogger - Audit:[timestamp=01-30-2025 15:19:56.578, user=username@email.com, action=login attempt, info=failed, src=1xx.1xx.1xx.1xx method=SAML]

It can be seen the user used to attempt login is a SAML user, which is not currently supported for ODBC connection:

method=SAML

Resolution

ODBC drivers communicates using the REST API talking to the management port, for this reason, SAML or SSO login is not supported and the user credentials must come from a local Splunk user.

 

Splunk Idea is currently in place to enable SAML support:

Make Splunk ODBC work with SAML authentication


Configure the Splunk ODBC driver with Microsoft Power BI

Revision History

Revision Publish Date Comments
1.0
29-Sep-2026
Initial Release

Was this Document Helpful?

FeedbackFeedback

Contact Cisco

This Document Applies to These Products