Forum Discussion

akwang's avatar
akwang
Icon for Advocate II rankAdvocate II
9 years ago
Solved

Get Data Access ODBC Links

I am trying to get data from an access file with a linked table.

 

But I don’t see those tables when I load into power BI. Can you help me?

Need Help
  • CahabaData's avatar
    CahabaData
    9 years ago

    It is because those are not Access tables.  You are displaying the Access navigation pane -  it shows the tables - but the icon of the Globe with arrow means that Access is in turn linking to another ODBC database.  These are not tables that reside within Access.

     

    You must link your PBI direct to that same back end database.

     

     

1 Reply

  • CahabaData's avatar
    CahabaData
    Icon for Memorable Member rankMemorable Member
    9 years ago

    It is because those are not Access tables.  You are displaying the Access navigation pane -  it shows the tables - but the icon of the Globe with arrow means that Access is in turn linking to another ODBC database.  These are not tables that reside within Access.

     

    You must link your PBI direct to that same back end database.