Forum Discussion

Abalestra's avatar
Abalestra
New Member
5 months ago
Solved

Postgre connection

Estoy teniendo un problema al momento de querer conectar power BI con una base SQL utilizada por mi sistema de gestión. El error cuando ingreso mi nombre de usuario, contraseña es que no me valida las credenciales ingresadas. No sé como resolver este problema.

 

 

POSTGRE SQL
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    5 months ago

    Thank you, lbendlin for your response.

    Hi Abalestra,

    We appreciate your inquiry on the Microsoft Fabric Community Forum.

    Based on our understanding, the issue whereby Power BI cannot validate PostgreSQL credentials may be related to driver configuration, cached credentials, or connectivity restrictions.

    Kindly follow the steps below, which may help to resolve the issue:

    1. Ensure that the PostgreSQL Npgsql driver required by Power BI is installed or updated.
    2. Clear any cached credentials in Power BI by navigating to File -> Options and settings ->Data source settings -> Global permissions ->Clear Permissions. Then reconnect and reenter the credentials.
    3. Check that the connection format in Power BI is servername:port and verify that the PostgreSQL port 5432 is open and not blocked by firewall or network restrictions.

    Additionally, please refer to the link provided below:
    Power Query PostgreSQL connector - Power Query | Microsoft Learn

    We hope that the information supplied helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

    Thank you.

5 Replies

    • nikkirai99's avatar
      nikkirai99
      Frequent Visitor
      6 days ago

      Hi, I am having the same issue. I can connect to the database from dbeaver but not from Power BI Desktop. The error message is Invalid Credentials. I downloaded the most recent Power BI Desktop version allowed by my company, cleared permissions from Global Permissions, close and reopen Power BI Desktop. 

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support
    5 months ago

    Thank you, lbendlin for your response.

    Hi Abalestra,

    We appreciate your inquiry on the Microsoft Fabric Community Forum.

    Based on our understanding, the issue whereby Power BI cannot validate PostgreSQL credentials may be related to driver configuration, cached credentials, or connectivity restrictions.

    Kindly follow the steps below, which may help to resolve the issue:

    1. Ensure that the PostgreSQL Npgsql driver required by Power BI is installed or updated.
    2. Clear any cached credentials in Power BI by navigating to File -> Options and settings ->Data source settings -> Global permissions ->Clear Permissions. Then reconnect and reenter the credentials.
    3. Check that the connection format in Power BI is servername:port and verify that the PostgreSQL port 5432 is open and not blocked by firewall or network restrictions.

    Additionally, please refer to the link provided below:
    Power Query PostgreSQL connector - Power Query | Microsoft Learn

    We hope that the information supplied helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

    Thank you.

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support
    5 months ago

    Hi Abalestra,

    We would like to follow up and see whether the details we shared have resolved your problem. If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

    Thank you.

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support
    4 months ago

    Hi Abalestra,

    We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

    Thank you.