In Data Source Registry (and Admin > Datasources), we need a new "System View" to be created in the database (when System Views is checked) that shows the count of records in all tables.  Here is the SQL to use:

CREATE VIEW [dbo].[boaTableCounts]

AS

SELECT     TOP (100) PERCENT INFORMATION_SCHEMA.TABLES.TABLE_CATALOG, INFORMATION_SCHEMA.TABLES.TABLE_NAME,

                      sys.sysindexes.rowcnt AS RecordCount

FROM         sys.sysobjects INNER JOIN

                      sys.sysindexes ON sys.sysobjects.id = sys.sysindexes.id INNER JOIN

                      INFORMATION_SCHEMA.TABLES ON sys.sysobjects.name = INFORMATION_SCHEMA.TABLES.TABLE_NAME

WHERE     (sys.sysobjects.xtype = 'U') AND (sys.sysindexes.indid IN (0, 1))