Forum Discussion
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. ...
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
