Connectivity issues (PBI > Netezza)

[ajohnso2]

Hi All,

Recently started getting some issues with refreshing semantic models on my desktop (refreshes still work fine through the service and on prem gateway), please see below error.

Hoping someone might have an idea whats going on.

It may just be coincedence but I noticed this behaviour on the same day my pbi client updated (Oct update 2.137.751.0).

All of our datasource connections use credentials of a Service Account setup within Netezza (local user type thing). 

Oddly if I use my own credentials to connect to Netezza instead then refreshes will work fine.

[Anonymous]

Hi @ajohnso2 ,
Since Netezza has now deprecated weaker authentication methods such as MD5 and Crypt. If your connection still uses these methods you can change it to SHA256, here is the documentation I found for you hope it helps!

Updating connections for crypto support - IBM Documentation

The 64-bit Power BI Desktop and Power BI Gateway require the use of 64-bit ODBC drivers. 32-bit drivers are not available in 64-bit environments, which means that you have to make sure that you use 64-bit drivers when configuring your data sources.

Solved: 32 Bit ODBC driver with 64 Bit Power BI - Microsoft Fabric Community
Of course, you can't rule out compatibility issues that occur after updating your Power BI client. If you still can't find a solution after trying the previous two steps, I recommend that you downgrade your version of Power BI Desktop in order to ensure that the program runs properly!

I hope my reply can solve your questions, if you have further questions, you can contact me at any time, I will receive your message the first time to reply to you, look forward to your reply!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[ajohnso2]

Hi thanks again for your earlier reply, I have looked into this in more detail.

I have confirmed with our database team that MD5 & Crypt are disabled on our netezza environment so this is a non issue, infact there have been no changes to the netezza appliance in recent months. 

I have tried disabling all of our firewalls -> no change

I have created a connection to our netezza environment with a DSN odbc connection (using ODBC connector in Power BI) THIS WORKS!!! But the Netezza connector doesn't... make it make sense...

Im quite confident this issue is something introduced in Octobers client update, to confirm it still doesn't work in November release either.

I'm not inclined to accept roll back to September release as a fix.

I would really appreciate someone looking into this as its taken up far too much of my time to date (Will i have to raise this as support?).

[ajohnso2]

Thanks,

However, I have rolled back to the September release and the issue goes away. I've read on these forums of other users having issues with connections (albeit to differing databases) on the oct release.

Can you confirm this is not a known bug (that will be addressed) in the Oct release.

[Anonymous]

Hi @ajohnso2 ,
Thank you for your feedback!
I'm glad to hear that you resolved the issue by rolling back to the September version. I'll check further to see if there are any known issues associated with the October release, and if so, we'll make sure to address them in a future update.
If any of the previously provided suggestions are helpful, you may consider marking them as solutions so that other users experiencing a similar situation can find a solution more quickly.
Thank you again for your patience and support!