Forum Discussion

BMB-UPMC's avatar
BMB-UPMC
New Member
8 years ago

Preparing Access Database for BI Dashboards

I have an Access database that contains tables that are linked to an Oracle database via an ODBC connection. When I attempt to “get data” and select the Access database, it does not recognize these tables. Can I not connect to an Access database that has linked tables?

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi BMB-UPMC,

     

    I tested on my side, Power BI can load Excel linked tables successfully from Access database. Please check this scenario on your side to see if issue persists.

     

    Regards,

    Yuliana Gu

    • BMB-UPMC's avatar
      BMB-UPMC
      New Member
      8 years ago

      It does not work for me.  I can connect to the Access database, but no tables are available to view.  It says "no items selected for preview" in the right pane.

       

      .