All Apps and Add-ons

Splunk ODBC: How to set up an ODBC connection string for Power BI?

New Member

I am trying to set up an ODBC connection via an on-premises gateway for Power BI. I can't figure out the correct connection string to use.

I have tried both:

Driver={Splunk ODBC Driver}; Server URL=mysplunkurl; Port=8089 and
Driver={Splunk ODBC Driver}; Server URL=mysplunkurl:8089

I keep getting the following error:

ODBC: ERROR [HY000] [Splunk]ODBC Not enough information
provided to establish a connection to
the data source and specified to not
prompt for more information.

I'm not sure what else to try, I've tried adding credentials to the string, that doesn't work because they are typed in separate. I've also tried just calling it "Server" in the string, instead of "Server URL". Also, no luck. Any help would be appreciated!

0 Karma

New Member

I don't see a solution for this issue even though the thread is old... 

I still see this issue. Anyone get past it?

0 Karma

Engager

This string works in our environment:

DRIVER={Splunk ODBC Driver};PORT=8089;PWD=myPW;SERVER=myServer;UID=myLocalUser;URL=https://myServer:8089;VERIFYSERVERSSLCERTIFICATE=N;

A great tool for building this is WinSQL. A free download is available, for debugging sql connections.

To use the tool, install the Splunk ODBC driver.

In the tool, create a new connection of type Connection String. Enter "DRIVER={Splunk ODBC Driver};" in the string field, and click OK. The tool then prompts for the rest of your connection settings. When complete, the tool writes the connection string, as above.

New Member

Hi Team ,
I am also having the same issue
alt text
when we connect Power BI to ODBC drivers it's having the issue . can you please let me know how can i solve this issue

0 Karma

Engager

Hi. Maybe you can try
dsn={Splunk ODBC};server=url:8089

{Splunk ODBC} is your DSN name in your local machine.

0 Karma

New Member

Thanks for the reply. I have tried that, and all the various combinations of that I can think of with no luck.

0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!