Forum Discussion

aknorr's avatar
aknorr
New Member
10 years ago
Solved

Connecting a Netezza DB to Power BI

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. 

Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • Fredoop's avatar
    Fredoop
    New Member
    10 years ago

    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!