Forum Discussion
Power BI Access Database
I copied one of the tables that was coming up "empty" and the copied table was available in Power BI Navigator.
Hi samye228
1.Please check that if you have Like operators that are not supported in Power query, you can refer to the following similar thread.
Solved: "This table is empty" - table Import from Access - Microsoft Fabric Community
Solved: Power Bi will not import query from Access with "L... - Microsoft Fabric Community
2.If the information above cannot solve it, you can consider to export the data in Access database to excel, then import the data in excel to Power query, you can refet to the following link.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
When I searched I did see some replies discussing the "like" operator. This is a table, there is no "like" operator involved. I'm not interested in exporting to Excel, if anything, I would write a query to access the information directly.
I would like the direct access because when a record is added and I refresh, I do not want to rerun the query. I'd like to access the data directly.
I thought it was interesting that when I copied the table, I was able to "see" it in the Power BI navigator and load it. But I can't copy every table just for Power BI. It is also interesting that when I create a new table, I am able to view it. The database was created in 1996 and I was thinking there might be an option in the database that is preventing Power BI from "seeing" the records.
Thank you for your reply.