Connecting a Netezza DB to Power BI

[aknorr]

Hello,

I am a new Power BI user and I am attempting to connect to a NZSQL database. This seems to be an option through an ODBC connection, but the tutorials are not very clear with respect to a specific NZSQL connection. 

Can anyone provide insight into this connection or point me at material besides the tutorials for this type of connect? 

Thanks in advance. 

[Fredoop]

While there isn't a native connection to Netezza in PowerBI, here is an end around that you can use to successfully connect the two systems. Start by using the R script data source function - you will need a local version of R installed on your box for this to work. Make sure you have the R library nzr installed into the local R home directory.

Once that is set up you can use a piece of R code to query Netezza tables back into dataframes in R which will then be loaded to PowerBI. Here is an exampe snippet of the R code required:

#start R code #

require(nzr) 

#Connect to Netezza Instance#

nzConnect("username","password","Netezza IP", force = TRUE)

#define SQL Query#

call <- paste("SQL Query")

#Put SQL Results into dataframe#

data <- nzQuery(call)

Once you run the R script you will be prompted to choose the dataframes you would like to load to PowerBI and you should be good to go. Little bit kludgy but it is a workaround until that connection is built out by MS.

Cheers!

[Greg_Deckler · Accepted solution]

The Idea for it is here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8038857-netezza

You can vote for it.