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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

0

Can't connect MariaDB with Power BI Desktop

I can't  connect MariaDB with Power BI Desktop through Get Data function.

Although I finished installing MariaDB, its connecter, Power BI Desktop and setting them up, I still can't find MariaDB option on the list of "Get Data".

Do I need other tools?

 

Each of versions are below:

PowerBI: 2.112.1161.0 64-bit (2022.12)
MariaDB: 10.10.2
MariaDB Connector: mariadb-connector-odbc-3.1.17-win64

 

Status: Delivered

Hi @Shoko_Kashiwagi 

First you need to download the ODBC connector for MariaDB and install it . For more information on the operation you can refer to this link below .

Simple method to connect to MariaDB in Power BI - BI (utashnanunkoo.com)

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Delivered

Hi @Shoko_Kashiwagi 

First you need to download the ODBC connector for MariaDB and install it . For more information on the operation you can refer to this link below .

Simple method to connect to MariaDB in Power BI - BI (utashnanunkoo.com)

 

Best Regards,
Community Support Team _ Ailsa Tao

Shoko_Kashiwagi
New Member

Hi @v-yetao1-msft , thank you for such a quick response!

Now I looked at Power BI Desktop again, and found that the option of "MariaDB" finally showed up on the list!

Although, I already installed and set up the ODBC connector when I raised this issue, and it seems to me that it took quite a long time to apply the setting.

Does it require to restart PC or any other operation to apply those settings?