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...
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! 

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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Sure Anonymous . Thanks!