Hello,
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.
12 answers
The "query for Tableau" in the attached has the follwoing SQL:
SELECT [Union Query].*
FROM [Union Query];
And here it is available in the data connection window:
