• LOGIN
  • No products in the cart.

Connecting Tableau to R

Have you ever wanted to connect Tableau to R to perform Advanced Analytics like Sentiment Analysis? Here's how

Connect Tableau Desktop to R in Under 30 Minutes

In this tutorial, we’ll walk through setting up an R server that we can connect our Tableau Desktop installation to in order to perform Advanced Analytics within our visualizations

Part 1: Setting up R Server


Click the link below to receive $100 in account credit to spin up your Server


  • After you’re all signed up, click the Create button and select the Droplet option

  • Click the Marketplace tab and select the See all Marketplace Apps option
  •  
  • Search for RStudio and select the first RStudio option 
  •  
  • Click on Create RStudio Droplet 
  • Choose the Standard $10/mo option 
  • Choose the datacenter region that you’re closest to (the numbers 1-3 don’t matter) and make sure the One-time password button is selected
  • Type in whatever hostname you’d like and click on Create Droplet. The server installation will kick off and you’ll receive an email in around 5 minutes with your server IP address and Root password

Part 2: Log into Server and Install R Packages

  • Check your email for your password. We’ll need this password to log into our droplet. 
  • Next, let’s click into our droplet so that we can access the Console button pictured at the far right. 

 

  •  
  •  
  •  
  •  
  •  
  • Click Console

  •  

Type root and press enter

Type in the password from your email and press enter. Re-enter that same password. 

Now we’ll be prompted to set up a new password. Choose whatever password you’d like.

Once you’re logged in, you may need to perform a system restart. If you see a message like the one pictured type sudo reboot and wait for the login screen to show up. Log back in with the root user and your new password.

Type the letter R to enter into R Server. Now let’s install some important R packages.

Manually type each of the following lines into your R server, one by one. You can try to copy paste each line, however, this can often bring along invalid characters.

install.packages('Rserve') install.packages('forecast') install.packages('dbscan') install.packages('tidytext') install.packages('syuzhet') install.packages('SentimentAnalysis')

When all of the R Packages listed above have installed, go ahead and quit out of R to enter into R Server. Type q() and choose to save your workspace by typing y

Now we’ve exited R and are back to our main server screen, it’s time for the last step which is enabling Tableau to connect to our server by via remote access. Type R CMD Rserve --RS-enable-remote

If you see that Rserv has started in daemon mode, it’s now time to open up Tableau Desktop and test the connection. Navigate to the Help menu -> Settings and Performance -> Manage External Service Connection

Make sure that the RServe option is selected from the dropdown menu and that the port is set to 6311. Enter in your server IP address which can be found within the email containing the password or from within your droplets menu. Press test connection to verify Tableau can connect to your R server.


 

Success!

If your test was successful, you can now start using R code within Tableau! If it fails, please read on.

Tableau + R Hands On Training

Let's put our R Server to work
Get Started

Troubleshooting

If Tableau is unable to connect to your R server, the first thing to try is a Windows or Mac restart. Once rebooted, retry. If it’s still failing, try to access the server from another Wifi connection. Your firewall may be blocking Tableau from connecting to your R Server. If your Server ever restarts, you’ll need to manually re-enable R Server remote connectivity. Log back into your server via the console and type R CMD Rserve --RS-enable-remote
February 28, 2020

0 responses on "Connecting Tableau to R"

Leave a Message

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.