include the logs.
Shawn - The message you're seeing indicates that the Microsoft Jet engine can't handle the question you're asking with Tableau against an Access / Text File / Excel data source.
Unless you make "the too complex thing" more simple, JET is going to get in your way.
Try creating an extract against this data source, and your error will likely go away.
Thanks Russell, that did the trick.
1 of 1 people found this helpful
The odd thing here though is that you only changed the location - the SQL should not have changed??
Alex, yeah I thought that was a bit odd too. Just now I tried several times to reproduce the error, and couldn't. If it ever comes back I'll pay more attention.