Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
jonboylib
Frequent Visitor

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 servername:port. The the database name below.

 

On the next screen I enter the user name and password, I know these credentials are correct as I have verified using HeidiSQL and MySql Workbench and can connect successfully from the same device.

 

I am able to setup a replica MariaDB on my device (localhost), import the remote db, and connect to localhost successfully using the same method.

 

I am also able to connect to the remote database via MySqlWorkbench etc. So the connection from my device is successful.

 

So it appears the issue is only with connecting to the remote db via power bi? 

 

The error message I am receiving is below; See images.

 

mdb1.png

 

mdb2.png

Any ideas?

3 REPLIES 3
jonboylib
Frequent Visitor

Still unable to connect to the remote mariadb, any ideas?

v-chenwuz-msft
Community Support
Community Support

Hi @jonboylib ,

 

Have you installed MariaDB ODBC Connector?

vchenwuzmsft_0-1641522821098.png

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.