Wednesday 27 July 2016

Don't use network drives with Tableau, use Network Locations

We have users that need to use Excel workbooks as datasources in their Tableau dashboards which are then published to Tableau server. However the problem lies with how Windows and Tableau use the network path names. 
Most people will connect to a shared drive by mapping a network drive, like this




And map the network drive to a letter, in this case Z. 



Now all that works fine and Tableau desktop will happily connect and all is right in the world. But if you then publish that workbook to the server, the problem arises with that drive letter. Tableau server has no idea what that Z drive is, it thinks it's a local drive on the server box somewhere and so it cannot find the correct file. This makes for a sad panda.



Instead we need to make sure that Tableau uses the UNC path name. The UNC path in this example is \\fastnfs\tableau_data_sources, the same that we used when we mapped the drive to the letter Z. 

Even though from here it knows the UNC path..



You can see the path that the data source is using by right clicking on the name in the data window and selecting properties




and if we click on the filename in the data connection window we can see it's defaulted back to use the drive letter. 



To fix this we need to edit that path to be the full UNC one



And then if we publish, Tableau server knows where to go and look for the file, assuming you have giving the Tableau Services user access to the directory.

This all works fine, except it relies on someone remembering to manual edit the path name to the full UNC path and not the driver letter name. 

The good news is that there is an easy solution to this and it's how you set up your access to the shared network drive in the first place. Instead mapping a network drive you map a network location. The process is the same as mapping a drive, except it doesn't get a drive letter. 



Choose the custom network location, click next.

Put in the UNC path for your shared drive



Give it a name



click finish and voila



We now have a new network location, note the different icon. 

Now if we create a data connection and use that instead of a lettered drive



And then check the data source properties we see it's got the correct UNC path, we havent typed a thing, not had to edit anything. 




Hope this helps anyone using files on a network share as a data source, if you need any help setting this up, just give me a shout. 

Matt

Author & Editor

Tableau Zen Master, Social Ambassador, Wrangler of Data, Vizzer of Data

45 comments :

  1. This comment has been removed by the author.

    ReplyDelete
  2. It's amazing!
    Solve my problem, thank you so much!

    ReplyDelete
    Replies
    1. Excellent article. IntelliMindz is the best IT Training in Bangalore with placement, offering 200 and more software courses with 100% Placement Assistance.

      Tableau Online Course
      Tableau Training In Bangalore
      Tableau Training In Chennai

      Delete
  3. This comment has been removed by the author.

    ReplyDelete
  4. That's great, been having this issue with some of our users and like you said getting them to remember to use the UNC path is causing lots of calls for dashboards not working. I'll be writing up a work instruction for them later using this as an example.

    Thanks

    ReplyDelete
  5. Great tip ! Thanks for sharing this Matt.

    ReplyDelete

  6. well done! the blog is good and it is about how tableau use network location it is useful for students and tableau Developers for more updates on Tableau

    tableau online course

    ReplyDelete
  7. Perfect article addressing an issue our team was wrestling with. Thank you!

    ReplyDelete
  8. Wow. great job! It’s amazing, thank you so much for gathering all this information in one post with Good Explanation, it’s very clever and will be extremely helpful for all people who use Tableau. Using subscriptions to deliver reports via e-mail in Tableau

    ReplyDelete
  9. Thanks! I've read on Tableau support forums to use the UNC instead of the letter but no one actually showed me how to do that. I appreciate the help.

    ReplyDelete



  10. It is really a great work and the way in which you are sharing the knowledge is excellent.Tableau Training in Chennai

    ReplyDelete
  11. Hello! I recently moved to a firm where they have to store all their data on network drive due to some reason. I am interested in setting this up because it's a lot of work to download, refresh and publish so many dashboards weekly. Can you please elaborate on "assuming that you have given tableau services user access to the directory" do I need a service account created? I am not the one handling admin stuff for tableau and the actual admin is not aware of any steps. Please help! Thanks :)

    ReplyDelete

  12. I appreciate your work on Tableau. It's such a wonderful read on Tableau.Keep sharing stuffs like this. I am also educating people on similar technologies so if you are interested to know more you can watch this:-
    https://www.youtube.com/watch?v=tpWt_dCDRP8

    ReplyDelete

  13. Really it was an awesome article… very interesting to read…
    Thanks for sharing.........


    tableau online training in hyderabad

    ReplyDelete
  14. Well done! It is so well written and interactive. Keep writing such brilliant piece of work. Glad i came across this post. Last night even i saw similar wonderful Tableau tutorial on youtube so you can check that too for more detailed knowledge on Tableau.https://www.youtube.com/watch?v=Ny6h82Qy4tA&t=34s

    ReplyDelete
  15. really loved reading through this article. Thanks for sharing sucha amazing post with us and keep blogging... best tableau online training in hyderabad

    ReplyDelete

  16. Very Impressive Tableau tutorial. The content seems to be pretty exhaustive and excellent and will definitely help in learning Tableau. I'm also a learner taken up Tableau training and I think your content has cleared some concepts of mine. While browsing for Tableau tutorials on YouTube i found this fantastic video on Tableau. Do check it out if you are interested to know more.:-https://www.youtube.com/watch?v=Ny6h82Qy4tA&t=11s

    ReplyDelete
  17. It is really a great work and the way in which u r sharing the knowledge is excellent.
    Thanks for helping me to understand basic concepts. As a beginner in Tableau your post helps me a lot. Thanks for your informative article.
    Online Tableau Course Training in Hyderabad

    ReplyDelete
  18. This comment has been removed by the author.

    ReplyDelete
  19. I appreciate what you folks are as a rule up as well. This kind of astute work and scope! Keep up the brilliant works folks I've added you all to my blog roll.
    Tableau online training in Hyderabad
    Tableau training in Hyderabad
    Online Tableau training in Hyderabad

    ReplyDelete
  20. 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 Hadoop Administration Online Traning

    ReplyDelete
  21. Very interesting blog. A lot of blogs I see these days don't really provide anything that I'm interested in, but I'm most definitely interested in this one. Just thought that I would post and let you know vpn guide

    ReplyDelete
  22. I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. was is diebesten vpn

    ReplyDelete
  23. Tableau décoration découvrez le spécialiste de la déco mural Moderne Tendance Contemporain Bouddha Nature Ciné  tableau déco

    ReplyDelete
  24. Really enjoyed this article post. Cool. jax corp

    ReplyDelete
  25. This is really too useful and have more ideas and keep sharing many techniques. Eagerly waiting for your new blog keep doing more.
    tableau training in hyderabad
    tableau onlinetraining in hyderabad

    ReplyDelete
  26. This is really helpful and have more ideas.keep sharing information with us.Thank you..
    Tableau Training in Mumbai

    ReplyDelete
  27. Thank u for posting such a kind article.keep sharing like these.

    http://www.rstrainings.com/adv-java-online-training.html

    http://www.rstrainings.com/core-java-online-training.html

    ReplyDelete

  28. Nice blog..! I really loved reading through this article... Thanks for sharing such an amazing post with us and keep blogging...
    Tableau online training
    best Tableau online training
    Tableau online training in Hyderabad
    Tableau online training in india

    ReplyDelete
  29. Replies
    1. This is very nyc blog and thanks for this usefull information and i found a new site for mule soft training institute to another information plzz check the below link ”https://svrtechnologies.com/mule-esb-training//”

      SVR Technologies MuleSoft training is designed according to the latest features of Mule 4.It will enable you to gain in-depth knowledge on concepts of Anypoint Studio Integration techniques, testing and debugging of Mule applications, deploying and managing the Mule applications on the cloud hub, dataweave transformations, etc. You will also get an opportunity to work on two real-time projects under the guidance of skilled trainers during this training.

      Enquire Now: +91 9885022027
      Enroll Now: https://bit.ly/2OCYVgv


      Features:

      >> Live Instructor LED Classes
      >> Experienced Faculty
      >> Free Video materials
      >> 24/7 Support
      >> Flexible Timings
      >> Lowest Fee


      MULESOFT KEYWORDS
      -----

      mulesoft training,
      mulesoft free training,
      mulesoft training videos,
      mulesoft videos,
      mulesoft certification,
      what is mulesoft,
      mulesoft tutorials,
      mulesoft tutorial for beginners,
      mulesoft online training,
      mulesoft training online,

      Delete
  30. Gracefully written information on this blog are going to support me for my coming assignments. Every point was very clear and taught me few new parameters. I would like to use this information in coming future.
    Lenovo ThinkSystem SR550

    ReplyDelete
  31. The above blog information provided above is really very nice.by your informartion i can improve my technical skills moreTableau Online Training

    ReplyDelete
  32. An author must have a vast knowledge of vocabulary. The dictionary of a writer must be full of new english vocabulary to make their work more attractive. Use of new words makes their work more valuable and graceful.
    CISCO CATALYST 3850

    ReplyDelete
  33. Obviously, the collection of a writer must be a bundle of creativity. New ideas of writing become the reason of success. It makes your work worthwhile. Everyone wants to praise your writing because they bound by creativity.
    TeraStation 3210DN Series

    ReplyDelete
  34. Excellent post, must say thanks for the information you added to this post. I appreciate your post and looking forward for more.
    tableau training in mumbai
    tableau course in mumbai

    ReplyDelete
  35. Thanks for sharing this great information. Learning tableau is a tricky task and one must get help from any source possible.

    ReplyDelete
  36. Nice Information. Thanks for sharing.
    Ensures best online Job Support.
    We help IT professionals by providing them Best Online Job Support in 250+ technologies. Our services are very reliable and most affordable. Call Today for free demo

    ReplyDelete
  37. Thanks for sharing valuable information and very well explained. keep posting.

    tableau developer training
    tableau developer course

    ReplyDelete
  38. Thanks for explaining how to get around the connection issue

    ReplyDelete
  39. Thanks for explaining how to get around the connection issue.it helped me

    Here is sharing some PostgreSQL may be its helpful to you.
    PostgreSQL Training

    ReplyDelete
  40. Hi,
    Great article! Your insights are spot on Don't use network drives with Tableau. I especially appreciate your point about Tableau desktop will happily connect and all is right in the world. It's evident you've done your research. Keep up the excellent work! Looking forward to reading more from you.

    Here is sharing xamarin online Training related stuff that may be helpful to you.
    xamarin online training

    ReplyDelete

 
biz.