Menu
    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?    
    PRINT THIS PAGE
    Related Links
    Attachments

    All Support

    SUPPORT BY PRODUCT
    TOOLS & DOWNLOADS
    INFORMATION
    ASSISTANCE