Queries including count(*) do not work with tableau

Setup:
ACS + Insight Engine (say, 1.4)
Also create a ODBC connection using CDATA driver.

Steps:
1. Using this ODBC connection as DSN, run the following query in Excel

Query: select SITE, count(*) from alfresco group by Site

2. Run the same query using Tableau,
The following error is returned.
Unable to execute the query, error caused by: Unknown field '*'.

Stacktrace:

Unable to complete action
[400] 07210012 Unable to execute the query, error caused by: Unknown field '*'. 
An error occurred while loading the data.
[400] 07210014 Unable to execute the query, error caused by: Unknown field '*'.
SELECT TOP 10000 `TableauSQL`.`SITE` AS `SITE`,
  `TableauSQL`.`count_42` AS `count_42`
FROM (
  select SITE, count(*) from alfresco
) `TableauSQL`

The issue does not seem to be qith CDATA driver as with excel, it returns the results.
Considering tools like Tableau provide working with measures and functions such as count(field) count, tried to change the query to:
select SITE, cm_name, `cm:content.size` from alfresco
in order to build the dashboard using Tableau features.

But 2 issues were seen:
1. count(field) isn't supported for Insight Engine hence an error is shown
2. count shows up as null

In order to support BI tools like Tableau, support for the count functions may be required.