Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
The Idea for it is here:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8038857-netezza
You can vote for it.
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!
The Idea for it is here:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8038857-netezza
You can vote for it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |