I have an active database I am connecting to and need to bring in the query output into tableau. When I do only 1 of the 4 queries I have within access display in the connection window despite all queries work and output data
1 answer
Hello claude raiola,
to help isolate the issue, can you connect to the other queries with a microsoft tool such as Microsoft Access and get results? The Microsoft Jet driver has many limitations.
Working With Jet Data Engine Limitations | Tableau Software
I hope this helps
Patrick