Friday, October 3, 2014

Force Extract To Be Built On Server Instead Of Desktop

The reason for using this trick would be if you have a large dataset you need to extract and want to prevent the extract file from being built on your desktop before you publish to Tableau Server.  Using this technique we can build an empty extract with 0 rows of data in it on your desktop, and then as soon as you run the extract refresh on Tableau Server (either manually using 'Run Now' or on a schedule) it will populate with the full dataset.

First step is create a calculated field which has the formula:
datetrunc('minute', NOW())


































This will roll the current time back the beginning of the minute (which makes it important that you do the rest of this quickly).

Next right-click you data source and choose 'Extract Data'.  Inside that window choose to add a filter and pick the new calculation you just made:




























On the next window pick 'Individual dates and times':




















And then 'exclude' the single timestamp you see in there:
























Your extract window should look like this and then you can click 'Extract':

























This should build an extract file that has 0 rows of data in it.  You can see this by right-clicking on the data source and choosing 'Extract->History':




















See that it imported 0 rows (my timestamp is slightly different than before because I had to take new screenshots):













Note:  If it didnt work it is probably because the minute has changed and the timestamp we excluded is too old.  If this is the case, change back to a live connection, then right-click the datasource and choose 'Refresh' (or click F5) to dump the cache and send a new query.  This will also update the timestamp to the current time and you can try again.

Now after you publish your workbook and either run the extract refresh schedule, or just pick 'Run Now', it will populate the full extract:











Yay our workbook now has data in it and we never had to build the giant extract on our desktops before publishing!









-The Don Data

5 comments:

  1. Replies
    1. I was searching for loan to sort out my bills& debts, then i saw comments about Blank ATM Credit Card that can be hacked to withdraw money from any ATM machines around you . I doubted thus but decided to give it a try by contacting { cyberhackingcompany@gmail.com} they responded with their guidelines on how the card works. I was assured that the card can withdraw $5,000 instant per day & was credited with$50,000,000.00 so i requested for one & paid the delivery fee to obtain the card, after 24 hours later, i was shock to see the UPS agent in my resident with a parcel{card} i signed and went back inside and confirmed the card work's after the agent left. This is no doubts because i have the card & has made used of the card. This hackers are USA based hackers set out to help people with financial freedom!! Contact these email if you wants to get rich with this Via: cyberhackingcompany@gmail.com ..    

      Delete
  2. This is a comprehensive and helpful piece of information. Thank’s for sharing. Using subscriptions to deliver reports via e-mail Tableau

    ReplyDelete
  3. Learn tableau and become a certified associate with the help of best tableau certification dumps

    ReplyDelete
  4. Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating

    Tableau Certification Dumps
    Tableau Certification Exams

    ReplyDelete