Power Bi will not import query from Access with "Like" criteria

[Jonnokc]

Hello,

I am new to Power Bi. I typically build all my queries in Access. I tried to import them into Power Bi, but Power Bi shows all my queries which contain a "Like" criteria as empty. Is there a workaround for this? This seems like a huge oversight.

Thank you,

[jdeast]

Hello, 

I am experiencing the same issue with "LIKE" criteria in a linked Access query.

Was there ever a resolution to this?

[itchyeyeballs · Accepted solution]

I just tried and get the same issue,

Two workarounds:

Connecting via ODBC seems to work, I set up a DSN and used = Odbc.Query("DSN=test;Uid=;Pwd=;", "SELECT * FROM tmp") although you can use a DSNless connection.

As an alternative workaround can you take the like clause out of the query and filter the data in Power BI? Not ideal but might resolve in short term.

[Jonnokc]

I technically could. What would be the equivilant of performing this in power bi?

For me this has always been very simple in access and has always been one of the reasons I love it. I can build out my queries and whenever I need to I simply update my data tables and boom, my filtered results.

If I can technically do a similar thing in power bi I would be all for that. Sadly I simply dont know how to do the same thing. How can I mimimic the contains function?