Forum Discussion
Connectivity Problem On-Premise Gateway for PostgreSQL and MariaDB
- 4 years ago
Thanks a million for your help. I finally solved the issue with your solution and installing this:
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.
- learningpower4 years agoNew Member
Thanks a million for your help. I finally solved the issue with your solution and installing this: