2 Replies Latest reply on Apr 16, 2018 2:51 PM by ShivaRam Chennapragada

    Any risk associated with switching from Live to Extract?

    Mike Barnett

      Is there any risk associated with changing from a live published data source to an extract after a dashboard is published and live? I want to improve performance/speed on a published dashboard, but don’t want to risk losing or altering anything (calculations, data types, mapping, etc.) Thank you for any advice on potential fallout.

        • 1. Re: Any risk associated with switching from Live to Extract?
          Jeevan Krishna

          Hello Mike,

           

          • You will not lose out on any existing functionality by changing your live connection to extract.Also, extracts do work faster compared to Live connections.
          • Only thing you need to remember while publishing the dashboard with an extract is to enable data refresh on tableau server. Else, your data will not be up-to-date.
          • You can read about how to do it here - Quick Start: Refresh Extracts on a Schedule (Point 3)
          • You can setup your refresh schedule as per your requirement like Hourly refresh or Weekly refresh etc.. depending on your data size and velocity.
          1 of 1 people found this helpful
          • 2. Re: Any risk associated with switching from Live to Extract?
            ShivaRam Chennapragada

            Hi Mike,

             

            There shouldn't be any issues when switching from Live to an extract. Tableau preserves all the calculations and aggregations associated to the view and yes you'd notice performance improvement. However, note that, when you make changes to .tds file it has to be re-published and extract has to be recreated. Other than the obvious difference that you won't see the freshest data rest all are non-issues.

             

            Hope this helps.

             

            Thanks,

            SHiva.

            1 of 1 people found this helpful