2 Replies Latest reply on Sep 22, 2011 5:30 PM by Makram Abu-Shakra

    How to limit OData transfer to filter value

    Makram Abu-Shakra



      We are developing an OData feed that our clients will hopefully use Tableau Public (or possibly Desktop) to access.  Since our tables can get very large, we don't want to send the entire dataset when the user refreshes.  There will be a filter of type "Compact List" so that what is displayed in the table is always only limited to the selected filter value.  How do we get Tableau to send an OData query which includes the filter so that only the filtered values get transferred across the internet connection?


      Thanks in advance,


        • 1. Re: How to limit OData transfer to filter value
          Lu Sien Tan

          Hi Makram,


          Unfortunately at the moment there is no way to send specific OData query during a refresh (or at any other time except for the initial connection).


          Would you mind sharing more details about how your clients might interact with the workbook?

          Perhaps we can find some other way to accomplish this.


          Few questions I have in mind:

          1. Does your OData feed changes quite frequently such that clients might need refresh it quite often?

          2. How many items are in the Compact List?

          3. Are particular clients only interest in specific filtered values? Perhaps you can split this into different sheets. Each sheet having a different odata url. That way they can be refreshed independently.




          • 2. Re: How to limit OData transfer to filter value
            Makram Abu-Shakra

            Thank you for your prompt reply.  To answer your questions:


            1) The data changes once a month, but it is quite large, possibly millions of rows.

            2) Number of items in the compact list would depend on the project, anywhere between hundreds and thousands.  We may go from using a compact list to a wildcard match when the list is large.

            3) Unfortunately, the specific interests would be ad hoc and hard to predict.


            We have used SQL based connections in the past with Tableau desktop and the queries sent to the database include in the WHERE clause the user-selected filtered items.  Hopefully, the same kind of query filtering will be supported for OData in future versions.


            Thanks again,