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
lucmel I never used MarioDB and unfortunately have no idea, I hope someone else can help.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.