All Apps and Add-ons

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

RachelS
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

darand
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

klojewski2
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.

supputur
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

sprijosh
Engager

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

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

0 Karma

RachelS
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
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...