cancel
Showing results for 
Search instead for 
Did you mean: 
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
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors