Forum Discussion

Ungaretti's avatar
Ungaretti
New Member
2 years ago
Solved

Gateway Appears in settings as Not Configured Correctly

Hey guys! I have a connection via odbc from power bi to Postgresql. I installed the gateway on the server with access to the database. I created the connection in power bi services with the databa...
Need Help
  • Ungaretti's avatar
    Ungaretti
    2 years ago
     
     
    The provocation given about using dsn made me understand the logic and find the solution.
The odbc settings on both the server and the desktop were correct, but on the power bi desktop I used a connection string setting the internal IP and this caused the service not to find the gateway.
To solve this, simply select the configured system dsn and do not fill in the connection string field, as the service connection always looked for the dsn and no longer for the ip.

    Best Regards!
sergej_og's avatar
sergej_og
Icon for Super User rankSuper User
2 years ago

Maybe additional one from my side.
Don't forget to install the ODBC driver on all your gateway machines.
Setup is working for me:

Install these components and try to establish a conncetion to your source.
Maybe firewall-rule is required.

Regards

Ungaretti's avatar
Ungaretti
New Member
2 years ago
Hello, I already have the odbc driver installed on the server, where the gateway is and on my machine.
Rules released on the firewall too.
  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    2 years ago

    Nice,
     - and you have created a working connection to your source from your gateway vm?
     - and you have created the same connection in your gateway (in Service)?

    Regards

    • Ungaretti's avatar
      Ungaretti
      New Member
      2 years ago
      I don't know if I understand your question, but I connect to the Power bi desktop base using an internal IP, when I publish the dash in the Service, I need to change the IP to a public IP.
All information is the same, except the IP change.
      • sergej_og's avatar
        sergej_og
        Icon for Super User rankSuper User
        2 years ago

        OK, I try to ask another way.
        1. Do you have a working connection to your source when you work with Dektop?
        Can you load the data and work on it? I hope your answer is a "yes".
        2. When you publish your semantic model to the Service you publish also your connection informations. Therefore you have to add your connection (credentials, url...) to the gateway in Service. Service will use this gateway information (connection) to get fresh data from your source.
        If you don't have your connection added you  will get the error message above.

        Maybe you can show your connection string in Desktop (pls no confidential data!) and on the other side your corresponding connection in Service.

        Regards