2 Replies Latest reply on Mar 18, 2014 12:16 PM by Laura Carspecken

    Data does not import from Access query with left join

    Laura Carspecken

      Hi Everyone,

       

      I have an Access query that I am trying to import, however Tableau just runs and runs and never imports any data. The query is fast in Access, and only contains about 85K lines. I let Tableau run for over 30 minutes and it still never imported.

       

      Some background on the issue - The query I was using used to pull in just fine, however I had to modify 2 of the join types in Access to be left joins since some of the data was not being captured. Since I changed the join properties in Access, Tableau no longer imports this data.

       

      My temporary workaround is to export the Access query into Excel, then import the Excel file into Tableau. Obviously this is not ideal, so I am hoping someone can provide insight into this issue!

       

      Thank you,

      Laura