Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Unable to connect to IBM Netezza via DirectQuery

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

 

Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    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's avatar
    Anonymous
    7 years ago

    Hi TeigeGao , 

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

    Thanks, 
    Jash! 

5 Replies

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi TeigeGao , 

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

      Thanks, 
      Jash! 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

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