Forum Discussion
MariaDB Data Source Error 'Unknown System Variable'
I am trying to connect to a mariadb on a remote server (same LAN), using power bi desktop. When I select the datasource connector MariaDB I am entering the MariaDB data source in the format serve...
Hi jonboylib ,
Have you installed MariaDB ODBC Connector?
You can following this article steps to connect MariaDB.
Getting Started with the MariaDB Direct Query Adapter for Microsoft Power BI
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.
hi v-chenwuz-msft Yes I have installed the MariaDB ODBC Connector
I was unable to connect to my localhost database until I installed this, so I know it's installed correctly.
It appears the issue is with connecting to the remote database only. I am able to connect to the remote database via MySQLWorkbench etc. So I know the connection from my device works also.