Direct Query Failing to Filter Strings With Apostrophes (ODBC: ERROR [42000])

[bham]

I'm connected to a BigQuery database and am using Direct Query to access the data. When I load in a field of strings with apostrophes in some of the values (eg. "Larry's Diner"), everything will initially load fine into a visual, but when you use a visual level filter to select on of  the apostrophed names, this error occurs:
Release:
October 2018

Product Version:
2.63.3272.40461 (18.10) (x64)

Error Message:
OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [42000] [Microsoft][BigQuery] (70) Invalid query: Syntax error: Expected ")" but got string literal 'S BAKERY' at [63:42].

It certainly seems like this is a Power BI problem, since BigQuery runs the same queries no problem on its own. So my questions are: is this a known Power BI issue and is there an available workaround that doesn't involve removing the apostrophes from the values?

[gjohnson]

Hi @v-yuezhe-msft ,

We have also come up against this issue. Having a timeframe for a fix would help us to determine the proper work around.

Thanks,

Georgette

[v-yuezhe-msft]

@bham,

The engineer is working on a fix for this issue.

Regards,
Lydia

[Anonymous]

Hi @v-yuezhe-msft ,

We found this issue affecting our company as well. What's the general timeframe to have a fix like this rolled out?

Thanks,

Nick

[bham]

Awesome! Thanks for all your help.

[v-yuezhe-msft]

@bham,

I can reproduce a similar error as yours, I have reported this issue internally:CRI 90186123, and will post back once I get any updates.

Regards,
Lydia