Forum Discussion
"This table is empty" - table Import from Access
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
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!