Unable to connect to IBM Netezza via DirectQuery

[Anonymous]

Hello, 

I am unable to connect to IBM Netezza via a DirectQuery. I am getting the following error message, 

However I am able to connect to IBM Netezza through ODBC connection but its not a live connection. I am looking for a live connection to Netezza database via DirectQuery or any other means. 


Thanks, 
Jash

[TeigeGao · Accepted solution]

Hi @Anonymous ,

Could you please check if you have enabled the "Encrypt connections"? In PowerBI Desktop, click "File->Options and settings->Data source settings". Double click on the "IBM Netezza" in the list, check it.

Best Regards,

Teige

[TeigeGao · Accepted solution]

Hi @Anonymous ,

Could you please check if you have enabled the "Encrypt connections"? In PowerBI Desktop, click "File->Options and settings->Data source settings". Double click on the "IBM Netezza" in the list, check it.

Best Regards,

Teige

[Anonymous · Accepted solution]

Hi @TeigeGao , 

After "unchecking" the encryption box and setting the privacy level as "None" it worked. 

Thanks, 
Jash! 

[Anonymous]

thanks @Anonymous , after so long it worked for me after I came across this.

[Anonymous]

Sure @Anonymous . Thanks!

[Anonymous]

@Anonymous  did you set up the ODBC for this connect before connecting with PowerBI. The "IBM Netezza" connector is not working for me.