Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aknorr
New Member

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. 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

The Idea for it is here:

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

 

You can vote for it.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Fredoop
New Member

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
Super User
Super User

The Idea for it is here:

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

 

You can vote for it.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.