Power BI Access Database

[samye228]

Hello,

I am not sure if this should be under Power Query. I am trying to Get Data from an Access Database (mdb) located on a server. I bring up the Access database and only certain tables are available, others display the message, "This table is empty."

I'm not an Access expert but I looked at the Property Sheet of the tables and there is nothing significantly different from the tables that will load to the tables that are "empty." This database was built in 1996. I've googled for "power bi, table empty" and no results were helpful. Obviously, the connection is good, else all tables would be "empty." Access and Power BI are 64bit.

Can someone provide some suggestions to try?

Thank you,

Carol

[samye228]

I copied one of the tables that was coming up "empty" and the copied table was available in Power BI Navigator. 

[Anonymous]

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.

[solved] Why does PowerBI show “This table is empty” when getting data from a Microsoft Access Datab...

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.

[samye228]

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.