If you are using Excel as your application for ODBC and you got an error stating: 'Base Table : <table> not found ' , it may mean that the role that is part of the query being run is different from the role of the user trying to run it.
Analyzing the query that is being produced by excel, it does have a format of:
SELECT <field> FROM<role>.<table>
For example, if the query being run is using the Administrator role but the user trying to access it is using a Sales Manager role, then this error may be received.
As a solution, make sure that the role being used in the query, matches the role of the user that is to run it.