Connectivity Problem On-Premise Gateway for PostgreSQL and MariaDB

[learningpower]

Hi all,

I am new with On-premise gateway for PowerBI. I have already donwloaded the program and it is working fine. I just wanted to connect to my localhost for educational purposes. I have checked access to the PostgreSQL Database through shell, pgAdmin and DBeaver and it has no errors. This means that the problem is not located here.

The issue comes when filling the form in the manage gateway area. I am introducing the same credentials as used to connect from DBeaver, PgAdmin and even PowerBI Desktop, but I keep getting the error shown in the image below.

This is the error that I get.

Could anyone help me? I also tried another database like MariaDB without success.

Thanks in advance.

[v-chenwuz-msft]

Hi @learningpower ,

The error message tells us it can not find the instance in any machines which installed the on-premise gateway. Please the check the following points:

1 Database system is running.

2 Try to log in the DBMS locally.

3 The service name of this instance is it right?

4 Gateway should be installed in the place where the gateway can connected the instance.

You can use Power BI Desktop to connect the instance and publish to service. Add the data source to the gateway by dataset settings avoid entering the wrong string to it.

Power Query PostgreSQL connector - Power Query | Microsoft Docs

However, a connector is required for MariaDB. The following link you can refer.

MariaDB Direct Query Adapter For Microsoft Power BI — MariaDB Enterprise Documentation

The same question has been solved in this post. Hope this helpful.

Solved: MariaDB Gateway Connection - Microsoft Power BI Community

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[learningpower · Accepted solution]

Thanks a million for your help. I finally solved the issue with your solution and installing this:

https://github.com/npgsql/npgsql/releases/tag/v4.0.10