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
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