The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Connect to mariadb from Power BI in direct query mode. Step "source" results in a query not supported in Direct Query mode

Hi all, I have installed the Mariadb 11.1.2, then I tried to connect from Power BI in direct query mode to a small Mariadb databaser. I am using the Mariadb connector 3.3.7-GA for windows x64

The connection to the Database works fine, I can see the table in Power Query, but when I click on the first step ("Source"), I get the yellow message "This step results in a query that is not supported in DirectQuery mode"

I tried with an older version of the connector (3.1.22) but I got the same message. I also tried with an older version of Mariadb: (10.9.8) same message.

Do you have an idea? Thanks in advance.

PYM

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.