Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Disable encrypt a connection to a PostgreSQL DB for direct query connection to power bi

Hi!

 

DirectQuery is working onPowerBI desktop and try to publish report to  PowerBi Service. After publishing the report to service its data credentials is showing with error. So i try to edit credential with correct details..But adding try to sign its showing an error like below.For connection i tried correct credentials only.

.Screenshot 2023-02-20 164158.png

 

After that i tried another approach.

In power bi desktop itself ,on data source settings option i unchecked  the encrypt connections and tried to again to get correctly report on power bi service.Its succeed.Actually my doubt was , whether my approach having any issue on security level or any other issue may be need to face on future?

Plse reply.

Capture.PNG

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , Assuming PostgreSQL is cloud DB, if not then you need on premise gateway.

if that is done(Cloud/Gateway), make sure ip whitelist is not an issue

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.