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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
abhijitsahay
Frequent Visitor

Power BI service doesn't recognize Postgres database credentials

All my reports that are connected by Direct Query to our Azure Postgres database stopped working today.  They all give this error:

 

Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again

Message: The credentials provided for the PostgreSQL source are invalid. 

 

I have tried all variants/possibilities I can think of - creating a new workspace, different security settings ("None", "Private", "Organizational", etc.) but nothing seems to work.  All the reports work perfectly in Power BI desktop.

 

Any help appreciated!

5 REPLIES 5
GilbertQ
Super User
Super User

Hi @abhijitsahay 

 

You should get the option to edit credentials for the data source?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Yes I do get that option and I've entered the credentials several times, for each of the Privacy Settings - None/Private/etc.  It just won't accept the credentials.

This is what I get - I'm 100% sure I am entering the user/pass correctly.

abhijitsahay_0-1652748373255.png

 

abhijitsahay
Frequent Visitor

There is no gateway in the picture, the Postgres db is in the Azure cloud.  (See below).

abhijitsahay_0-1652739073436.png

 

GilbertQ
Super User
Super User

Hi @abhijitsahay 

 

What happens when you look at the Gateway can it still connect?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors