4 Replies Latest reply on Sep 22, 2016 5:57 AM by Zeeshan Hussain

    Error while communicating with the data souce

    Tara Cai

      Hi All

      I connect Tableau to my local SQL database, and it returns "an error occurred while communicating with the data source"

      tableau_error.png

      I clicked for "Show Details" and it says "Cannot mix aggregate and scalar expressions."

       

      I checked all worksheets that use this data source. All measures created from this data source work well, and do not complain about mixing aggregate and scalar expression. This error only appears when I try to refresh the data source. Does anyone know why and how to fix it? Thank you