KNOWLEDGE BASE

Error "Function not found: exact_count_distinct" Connecting to BigQuery Data Source


Published: 30 Nov 2016
Last Modified Date: 19 Jun 2017

Issue

When connecting to BigQuery using the exact_count_distinct function, the following error might occur: 
 
The Google BigQuery service was unable to compile the query. 
Function not found: exact_count_distinct at [...] 
Unable to connect to the server "googleapis.com/bigquery". Check that the server is running and that you have access privileges to the 
requested database.

Environment

  • Tableau Desktop 10.1.1
  • BigQuery 

Resolution

Option 1

Rewrite the query using count(distinct ...) instead of the exact_count_distinct function. 

Option 2 

Use the previous BigQuery connector found in 10.0 and earlier. 

Cause

The exact_count_distinct function is not in the new BigQuery SQL API.
Did this article resolve the issue?