IBM Netezza error Certificate Chain Not Trusted

[RandyPgh]

Although we have successfully used an ODBC connection in Power BI to connect to our IBM Netezza, we would prefer to use the the built-in IBM Netezza connector. However, we have had no success with it. We enter the server name, the database name, click Next, enter the user account and password. Clicking OK then gives us the dialog "Truststore error: Certificate Chain error".

We have reviewed and attempted various suggestions in this forum, including unchecking the Encrypt box in the Global Permissions. In fact, when we change Global Permissions and then try to create a new connection via Get Data, Power BI does not use the existing permissions but creates a new Global Permissions entry (see screen capture below).

Are Global Permissions supposed to be "picked up" and used by the Data Sources dialog? If we are missing a step or process somewhere, please share.

Also saw this thread, but the Netezza dialog in Power BI does not allow users to switch the type of credential.

https://community.powerbi.com/t5/Power-Query/Certificate-Chain-Not-Trusted-Error-Effecting-PowerBI-O...

Any other thoughts what the blocker might be?

Thank you!

[Anonymous]

HI @RandyPgh,

Did you get a solution to this? I have the same error after updating to Septemembers release. 

[RandyPgh]

We did not resolve the issue. We kept using the ODBC solution.

Randy

[TeigeGao]

Hi @RandyPgh ,

In this scenario, I would suggest you opening a ticket at https://powerbi.microsoft.com/en-us/support/

Best Regards,

Teige