You may have some luck digging into the Tableau Desktop logs to figure out whats going on. Check out this article: Sending Tableau Desktop Log Files | Tableau Software to create "clean" logs and then recreate the issue. The Tableau Desktop logs will likely contain additional information about what is causing the problem. If not, it will still be valuable information when opening a case with Tableau Technical Support: http://www.tableau.com/support/request
Hope this helps!
1 of 1 people found this helpful
Tableau support just confirmed that they have a limitation "The ability for Tableau Desktop to query nested fields in a Google BigQuery connection with Standard SQL is not a current functionality of our product."
Lacking this feature might impact performance since the workaround is using Legacy SQL or FLATTEN data.
I create the following idea in order to see if we can push this missing feature into Tableau product.