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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors