Splunk and Power BI

Question

Hi Everyone,&nbsp;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?&nbsp;Thanks,&nbsp;Giles

anonymous · Answer

Hi,Below are the steps you need to perform to connect the splunk data with power Bi.- Download the odbc 64 bit driver fromhttps://splunkbase.splunk.com/app/1606/- Install the driver and create a new DSN connection from splunk data source in odbc 64 driver.- Fill the&nbsp; 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.&nbsp;hope it will help.&nbsp;Thanks,&nbsp;&nbsp;&nbsp;&nbsp;

pqian · Answer

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?

anithat · Answer

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

shivacowarish · Answer

Hi,&nbsp;there's actually an app for doing this but I didn't try it yet:&nbsp;splunkbase.splunk.com/app/3953&nbsp;cheers!&nbsp;&nbsp;

anonymous · Answer

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&nbsp;"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:-2147467259Underlying error message:ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedDM_ErrorDetailNameCode_UnderlyingHResult:-2147467259Microsoft.Data.Mashup.ValueError.DataSourceKind:OdbcMicrosoft.Data.Mashup.ValueError.DataSourcePath:dsn=Splunk ODBC DriverMicrosoft.Data.Mashup.ValueError.Reason:DataSource.Error

Forum Discussion

Splunk and Power BI

5 Replies

Related content

Splunk connection to Power BI

Splunk for Power BI

Power BI API for Splunk

Power Bi Reports to be Shared in Splunk

Power Automate is free with Power BI Pro Licence

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