# Elastic search and Tableau Integration using ODBC **URL:** \ **Category:** Elasticsearch\ **Created:** [March 12, 2019, 12:36pm UTC](https://discuss.elastic.co/t/elastic-search-and-tableau-integration-using-odbc/171948 "2019-03-12T12:36:33Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![nikhil\_tarigonda](https://avatars.discourse-cdn.com/v4/letter/n/258eb7/32.png) [@nikhil\_tarigonda](https://discuss.elastic.co/u/nikhil_tarigonda)\ **Post date:** [March 12, 2019, 12:36pm UTC](https://discuss.elastic.co/t/elastic-search-and-tableau-integration-using-odbc/171948/1 "2019-03-12T12:36:33Z")
Hi, I am facing few issues when accessing my data set from Elastic search to Tableau. Few fields in my data set do not support live in tableau. I know that the ODBC is still under development, when can I expect the stable version? i have also tried the Dremio, but it still doesn't work. Is there any way to fix it? ---
**Author:** ![forloop](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/forloop/32/9021_2.png) [@forloop](https://discuss.elastic.co/u/forloop)\ **Post date:** [March 13, 2019, 12:37am UTC](https://discuss.elastic.co/t/elastic-search-and-tableau-integration-using-odbc/171948/2 "2019-03-13T00:37:03Z")
Would you be able to provide more details about which fields are not supported and what error messages you are seeing? Your feedback on this would be super useful here and this additional detail would help understand where the underlying issue is. /cc @bogdan.pintea ---
**Author:** ![nikhil\_tarigonda](https://avatars.discourse-cdn.com/v4/letter/n/258eb7/32.png) [@nikhil\_tarigonda](https://discuss.elastic.co/u/nikhil_tarigonda)\ **Post date:** [March 13, 2019, 7:03am UTC](https://discuss.elastic.co/t/elastic-search-and-tableau-integration-using-odbc/171948/3 "2019-03-13T07:03:43Z")
In my data set of kibana sample flight data, timestamp field and measure values are not supported. Also I have tried multiple data sets but the issue is the same. Other custom fields like calculated fields are also not supported in live but are supported in extract. Thank You. ![Screenshot%20(11)](https://us1.discourse-cdn.com/elastic/original/3X/a/5/a51715552f904f408b5af0bc6ba5d2fadce940bf.png) ![Screenshot%20(12)](https://us1.discourse-cdn.com/elastic/original/3X/5/e/5e6b167002665fe85c1f730e72d60b73529d1b81.png) ---
**Author:** ![nikhil\_tarigonda](https://avatars.discourse-cdn.com/v4/letter/n/258eb7/32.png) [@nikhil\_tarigonda](https://discuss.elastic.co/u/nikhil_tarigonda)\ **Post date:** [March 13, 2019, 7:16am UTC](https://discuss.elastic.co/t/elastic-search-and-tableau-integration-using-odbc/171948/4 "2019-03-13T07:16:49Z")
![Screenshot%20(15)](https://us1.discourse-cdn.com/elastic/original/3X/5/e/5e6a9b6054b858266bdfba4a82b83932dd7eed23.png) In this picture I have created a COUNTD() calculation field in live. The issue is with ODBC in live. I am facing the same problem even with the Microsoft Power BI. Thank You. ---
**Author:** ![bogdan.pintea](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bogdan.pintea/32/45740_2.png) [@bogdan.pintea](https://discuss.elastic.co/u/bogdan.pintea)\ **Post date:** [March 13, 2019, 4:06pm UTC](https://discuss.elastic.co/t/elastic-search-and-tableau-integration-using-odbc/171948/5 "2019-03-13T16:06:40Z")
Thanks for trying out our SQL implementation. There seems to be a defect here in the way we handle the `GROUP BY` in the statement generated by Tableau. I've opened an issue to follow-up on this ([https://github.com/elastic/elasticsearch/issues/40001](https://github.com/elastic/elasticsearch/issues/40001)). Thanks for bringing it up to us. ---
**Author:** ![bogdan.pintea](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bogdan.pintea/32/45740_2.png) [@bogdan.pintea](https://discuss.elastic.co/u/bogdan.pintea)\ **Post date:** [March 13, 2019, 4:11pm UTC](https://discuss.elastic.co/t/elastic-search-and-tableau-integration-using-odbc/171948/6 "2019-03-13T16:11:48Z")
This should normally work, except for the case a field contains an array of values (vs. just one value). We have an issue tracking this already ([https://github.com/elastic/elasticsearch/issues/39700](https://github.com/elastic/elasticsearch/issues/39700)) and hope to have soon a solution for it. Could this be the case with the `bank`.`lastname` index? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 10, 2019, 4:11pm UTC](https://discuss.elastic.co/t/elastic-search-and-tableau-integration-using-odbc/171948/7 "2019-04-10T16:11:57Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.