"This table is empty" - table Import from Access

[Anonymous]

Hello!

So, I am having somewhat of a strange issue and am not sure how to solve. I am attempting to import a table from an Access database, but I receive the message "this table is empty" even though the column names show. Based on other threads similar to this, I thought it might be related to my account permissions, however, I have already imported several tables from this database with no issue.  Well, I finally diagnosed the problem, which was a Like operator in the query (image below). When I removed the criteria, the table shows up in PowerBi. I should also note that the query runs just fine in Access.

Any suggestions/feedback would be much appreciated, thanks!

[duyarra]

Hi,

I just had the same issue and solved by replacing "*" for "%" where they showed in the SQL code for the view. 

This didn't work:

[..]  WHERE (((Clientes.NombreComercial) Like "*ENLACE*"))

But this worked both in Excel get and transform and in the Power BI's query editor:

[..] WHERE (((Clientes.NombreComercial) Like "%ENLACE%"))

I has to do with the SQL ANSI 92 compatibility issues in Access. I hope it helps!

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Power BI Desktop will not directly import those Access queries which have  Like operator. In your scenario, you can connect to the data source using ODBC connector instead, or remove the like operator, then import data to Power BI Desktop, and filter data in Power BI.

There is a similar thread for your reference.
https://community.powerbi.com/t5/Desktop/Power-Bi-will-not-import-query-from-Access-with-quot-Like-quot/td-p/8038

Regards,
Lydia