10 Replies Latest reply on Dec 18, 2017 8:05 PM by Chadd Dumagas

    Union query in access not pulling through into Tableau?




      I created a Union All query in Microsoft Access and I'm able to see the data fine in there. However when I connect to Tableau, that query isn't visible in the pane on the left hand side which shows my table. Does anyone have any ideas why that is and how I could resolve? I tried pasting the SQL from Access into the Custom SQL window but it kicked back an error saying it couldn't communicate with my data source. I'd really prefer to use this query I created in Access and not have to make any work-arounds.