Custom query using MariaDB ODBC connector

[lucmel]

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.

Now it seems using the new MariaDB Connector is not possibile to run a custom query:

I selected DirectQuery but nothing...

Do you know if there is a way to run a custom MariaDB query?

Thank you in advance!

[Hichamus]

Hello, did you find a solution for custom query using ODBC MariaDB connector ?

[guro2525]

Hello Dear Friend,

Did you find any soluiton to get data using custom query (ODBC MariaDB connector)?

Will be very thankful is somebody share any solution.

Best Regards,
Guram

[v-shex-msft · Accepted solution]

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

[WimBi]

Hi @v-shex-msft 

But does that mean you can't have a direct query anymore? Because i'm looking for a directquery mode, where i can still use a custom SQL statement

Best regards,

Willem

[parry2k]

@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.

[lucmel]

Understood. 

So,  do you know any version of the MariaDB connector for PowerBI that allows you to insert custom queries?

[parry2k]

@lucmel Custom query option is based on the connector you are using and not all the connectors have this option, and seems like this case for the MariaDB.

✨ 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.