Skip to Content
Former Member
Mar 12, 2013 at 10:41 AM

Excel - This data source contains no visible tables


After upgrading to SPS5 (HANA Onge on Amazon Web Services) all attempts to connect to HANA analytic and attribute views using Excel and MDX results in the Excel message "This data source contains no visible tables". This was generally successful in SPS4.

This is a very simple model with one attribute view and one analytic view. Both appear to save, validate and activate. The column views (attribute, hierarchy and analytic) can be queried via the Data Preview tool and SQL. All attributes have Drill Down and Hierarchy Active = True. The analytic view has Multi Dimensional Reporting = True.