Forum Discussion

New Member

4 years ago

Solved

Custom query using MariaDB ODBC connector

Hi All, I switched from MySQL connecto to MariaDB connector on POwer Bi Desktop. Using the MySQL connector I was able to select "Advanced Oprions" and insert a SQL Statement for custom query. ...

Need Help

Tutorial Requests

Anonymous
4 years ago
Hi lucmel,

I'd like to suggest you use the basic odbc connector to get data, you can use this data connector with MariaDB connection string and the custom query:

Power Query ODBC connector - Power Query | Microsoft Docs

Creating a Data Source with MariaDB Connector/ODBC - MariaDB Knowledge Base

Regards,

Xiaoxin Sheng

Anonymous

Not applicable

4 years ago

Hi lucmel,

I'd like to suggest you use the basic odbc connector to get data, you can use this data connector with MariaDB connection string and the custom query:

Power Query ODBC connector - Power Query | Microsoft Docs

Creating a Data Source with MariaDB Connector/ODBC - MariaDB Knowledge Base

Regards,

Xiaoxin Sheng