cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GilesWalker
Skilled Sharer
Skilled Sharer

Splunk and Power BI

Hi Everyone,

 

The IT manager has mentioned Splunk may be a useful tool to extract data we need from some of our machines. I was wondering if anyone has linked the Splunk data with Power BI or knows if it can be done?

 

Thanks,

 

Giles

5 REPLIES 5
rajveer1117
Helper IV
Helper IV

Hi,

Below are the steps you need to perform to connect the splunk data with power Bi.

- Download the odbc 64 bit driver from

https://splunkbase.splunk.com/app/1606/

- Install the driver and create a new DSN connection from splunk data source in odbc 64 driver.

- Fill the  server details userid and password.

- Goto Power Bi and add new connection.

- Click on odbc and then provide credetials for splunk server and then connect.

-Select the tables from the database.

-load the data in power bi.

 

hope it will help.

 

Thanks,

 

 

 

 

Anonymous
Not applicable

I am able to use the 64-bit Splunk ODBC driver with Power BI Desktop just fine, but when I install the 64-bit version on our Windows Server 2012 R2 and attempt to add a data source to the gateway in the service then I get this error. At one point there was an error about "C:\Program Files\Splunk ODBC Driver\lib\SplunkDSII.dll" not being found, but it is installed. From what I have read this could indicate that the wrong version (32 vs 64) version of the driver is installed but I confirmed I do have the 64-bit. Any ideas?

Savers Data Gateway:Unable to connect to the data source undefined.
Underlying error code:-2147467259
Underlying error message:ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:Odbc
Microsoft.Data.Mashup.ValueError.DataSourcePath:dsn=Splunk ODBC Driver
Microsoft.Data.Mashup.ValueError.Reason:DataSource.Error
pqian
Microsoft
Microsoft

Splunk support is not in PowerBI yet and there is an user voice page for this:

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7018273-pull-data-from-splunk

 

meanwhile, PowerBI comes with a pretty powerful ETL tool, why not give it a try to extract those data for you directly?

Hi All

 

I could see no updates to the below idea. Is there any other way to connect to Splunk data. Please advise.

 

 

Hi,

 

there's actually an app for doing this but I didn't try it yet:

 

splunkbase.splunk.com/app/3953

 

cheers!

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors