Forum Discussion

Rob6391's avatar
Rob6391
New Member
9 years ago

Get data from an Access DB

Hello,   I have just started with Power BI and have an issue when trying to get data from an Access database.   Only a few of the tables and queries contained in the Access database, are actually...
Need Help
Rob6391's avatar
Rob6391
New Member
9 years ago

Hi Lydia,

 

Thank you for your reply.

 

Only a few of the tables were visible in Power BI Desktop Navigator.  When I try to load them in Excel, I get the same result.

 

I have also tried with Administrator rights, but still get the same result.

 

For now, so that I can move on and use Power BI, I have exported the data that I need from Access into Excel, and then imported it into Power BI.  This works very well. 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Rob6391,

Would you mind sharing me the Access database file? I will test it in my Desktop. Based on your test, some tables in Access are  invisible in other tools, I would recommend you post the question in the Access forum to check if there are any restrictions or limitations on these tables.

Thanks,
Lydia Zhang