2 Replies Latest reply on Jan 16, 2018 8:30 PM by Christopher Wen

    Tableau is pulling data from a Microsoft Access Query Table that is not reflective of the queries in Acces

    Christopher Wen

      Hi Everyone,

       

      New here first post / question. I have written a query with filters in Microsoft Access, to get rid of some specific field types (via a WHERE NOT LIKE with wild cards). When I connect this table to Access, it pulls as if that line of query to filter these items out does not exist; that is:

       

      Access Table with filters: 2,000 data points.

      Access Table without filters: 27,000 data points.

       

      Tableau is connected to Access Table without filters. However, data set / data extract being reflected in Tableau has all 27,000 data points. Any reason why this might be?