MariaDB: Filtering table leads to syntax error "check for right syntax to use near 'INTEGER) <> ?'"

[davidkesselheim]

Hi,

I am using the MariaDB 3.1.16 connector to get data from a DB. 

There is a column that I need to filter where I need to get all rows except the ones containing -2 in that column.

To that end I open Power Query Editor ("Edit Query") and then add the filter:

This seems to work as it shows me only the wanted values in Power Query Editor, but when I click "Close & Apply" I get a syntax error "check for right syntax to use near 'INTEGER) <> ?'":

Is there a workaround? If not, is this the right place to bring attention to this issue?

Thanks,

David

[Anonymous]

Hi @davidkesselheim 

It seems that INTEGER is causing the syntax error. You can check your M language for any related syntax issues. You can check it in Advanced Editor in Power Query Editor .

Best Regards,
Community Support Team _ Ailsa Tao

[davidkesselheim]

@Anonymous 

Thanks for the reply. As I said, it works in power Query, but not in PowerBI. The refresh gives the above error.

Here is the code from Power Query

let
Source = MariaDB.Contents("myserver.eu-central-1.rds.amazonaws.com", "mydb", true),
dim_zeittag_Table = Source{[Name="dim_zeittag",Kind="Table"]}[Data],
#"Filtered Rows" = Table.SelectRows(dim_zeittag_Table, each [jahr] > 2017)
in
#"Filtered Rows"