Forum Discussion

Didi_NewFlyer's avatar
Didi_NewFlyer
Frequent Visitor
10 years ago

Access DB - Tables are empty?

i finally got to the point where we could load the mdb file. The Power BI recongizes the table, so it lists them all. However, it says they are all empty. We open access and they for sure are not empty. No error happens. We just can't access the information??

Need Help

3 Replies

    • garma09's avatar
      garma09
      New Member
      2 years ago

      Hi Greg_Deckler , I have the same problem. I can see all the tables but they are all empty when I try to import them. They are linked tables. Is there a solution to this problem? 

       

      Thank you!

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    10 years ago

    Didi_NewFlyer

     

    As PowerBI(PBI) accesses Access DB normally with common drivers(Jet or ACE.OLEDB), IMHO, there's no difference between PBI and any other programs using the same drivers when accessing Access.

    So I think your question can be generalized as when accessing Access externally through drivers the table shows empty. I don't know about Access, just a guess this may be caused by insufficient permission or any limitation or feature in Access? 

     

    Starting from Access end might be a good idea in personal opinion and there's a dedicated msdn forum for Access.