Unable to Fold Query using MariaDB Direct Query Adapter for Power BI - Source

The node you attempted to view is archived.

Revision: 135005
User: Alish Bista
Date: 2024-02-06 05:11

I installed the mariadb-connector-odbc-3.1.20-win64 ODBC connector and used the MariaDB connector in Power BI.

Then I used the Direct Query mode to connect to the database. I was able to pull some of the data from column (containing text) in the database's table but while trying to get the count of another column (containing numbers) I ran into 'ole db or odbc error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression..'.  Now, getting count should be a simple expression and the number of rows is also shy of a few hundred thousand. I even tried extraction of that particular column only in Power Query but the same error. (I was using credentials with appropriate access)

Now, I tried the same with Import mode and it worked flawlessly. But I need to implement Direct Query mode to leverage near real time reporting.

Additionally, with DirectQuery some relationships would show a cardinality of Many to Many while they were in fact they were observed to be Many to One using Import mode.

Also, the 'View Native Query' option is greyed out from the very first 'Source' step in both DirectQuery and Import mode.

Any guidance on how to troubleshoot this would be appreciated.

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.

Unable to Fold Query using MariaDB Direct Query Adapter for Power BI - Source

Products

Solutions

Resources

Company

Pricing

Download MariaDB