[bug] postgre refresh doesn't work in pro

[turovmihail]

 

I have a data source that works good in desktop. Database is postgresql. No encryption used ([1 image]). Refresh works well. 

After i published it to pro version and try to refresh data source there is error: "The PostgreSQL source doesn't support encrypted connections." ([2 image]).

I don't understand why encryption automaticaly turned on on pro server. Unfortunately I can't find interface to turn off encryption ([3 image]).

https://i.imgur.com/9Vgqfea.jpg

https://i.imgur.com/O70XL6M.jpg

https://i.imgur.com/gBbkKUJ.jpg

[v-chuncz-msft]

@turovmihail 

Try the latest version of Power BI Desktop and gateway. You may also create a support ticket for assistance.

[turovmihail]

@v-chuncz-msft thank you

Sorted this out.

• downloaded on premises data gateway from power bi web interface.
• installed it full mode (not personal).
• installed npgsql https://github.com/npgsql/Npgsql/releases. power bi works with older versions. As of 2019.02.12 latest is 4.0.10. During installation enabled Npgsql GAC Installation.
• Restarted my PC.
• In power BI web interface went to data set. Enabled gateway connection. Added my postgresql to data sources, in advaced settings turned encrypted connection off. Went back to data set, enabled gateway connection.

It seems that connecting postgesql is too hard in power-bi pro. It shold work from box or microsoft shold give instruction to do it.