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 Francis

Author & Editor

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

27 comments :

  1. This comment has been removed by the author.

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

    ReplyDelete
  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. Enpersol offers Best Tableau Services, specializing in implementation and dashboarding in pune and indore. We are Best Tableau consultants in India.

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

    ReplyDelete
  7. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in TECHNOLOGY , kindly Contact MaxMunus
    MaxMunus Offer World Class Virtual Instructor led training on TECHNOLOGY. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 1,00,000 + trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Saurabh srivastava
    MaxMunus
    E-mail: saurabh@maxmunus.com
    Skype id: saurabhmaxmunus
    Ph:+918553576305
    www.MaxMunus.com


    ReplyDelete
  8. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Tableau.
    MaxMunus Offer World Class Virtual Instructor led training on Tableau. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Nitesh Kumar
    MaxMunus
    E-mail: nitesh@maxmunus.com
    Skype id: nitesh_maxmunus
    Ph:(+91) 8553912023
    http://www.maxmunus.com/


    ReplyDelete
  9. BlueHost is one of the best website hosting provider with plans for any hosting needs.

    ReplyDelete

  10. 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
  11. Perfect article addressing an issue our team was wrestling with. Thank you!

    ReplyDelete
  12. 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
  13. 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



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

    ReplyDelete
  15. 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

  16. 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
  17. The information which you have provided is very good. It is very useful who is looking for Java online training Bangalore

    ReplyDelete

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


    tableau online training in hyderabad

    ReplyDelete
  19. 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
  20. really loved reading through this article. Thanks for sharing sucha amazing post with us and keep blogging... best tableau online training in hyderabad

    ReplyDelete

  21. 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
  22. 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
  23. 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

 
biz.