[ODBC-409] PowerBI measure with text filter raises SQL syntax error Created: 2024-01-08  Updated: 2024-01-13

Status: Open
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: 3.1.20
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Florian Rieupet Assignee: Lawrin Novitsky
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Power BI Desktop

Attachments: PNG File error_powerbi.PNG    
Issue Links:
Relates
relates to ODBC-312 PowerBI import data with text filter ... Open
relates to ODBC-358 PowerBI mixed mode SQL with cast() in... Open

 Description   

Hello,

I have an error when working with one of my column, every others are fine. I attached it.
I don't know if that can help, but when I do the exact same thing on other columns of the database it works fine, but for this specific column 'ad' it isn't working. It is a CHAR column with a maximum size of 1.

I can't share access to the database here as it is public, but I would happily share the access via mail.
If you have any question you can ask me.

have a good day
Florian

 Comments   
Comment by Lawrin Novitsky [ 2024-01-13 ]

Thank you for your report. There is no need to give us access to the database. What we would need is problematic table structure and how to re-create the problem in PowerBI. Other useful thing could be ODBC trace for the issue.

There were couple of somehow similar issues, in some cases people could find a workaround. I will link them here

Generated at Thu Feb 08 03:28:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.