We use a .vbs script to accomplish this. Open in a text file and save with the extension (.vbs). This one is currently set to be in Full Screen mode and uses IE to render the view. It is also set to refresh every 30 seconds (Wscript.Sleep 30000=30 seconds). Replace the [URL GOES HERE] with your URL.
*Note: To close / exit use Task Manager and end the instance. I am sure there are other ways, this is just how we accomplish this.
On Error Resume Next
Set objExplorer = CreateObject("InternetExplorer.Application")
objExplorer.Navigate "[URL GOES HERE]"
objExplorer.Visible = 1
objExplorer.FullScreen = True
Set objDoc = objExplorer.Document
Do While True
If Err <> 0 Then
Thanks Andrew Bickert for the reply.
I would like to try this and see if it works on Tableau Online(Tableau Server) and see, Could you please provide me with the step by step instructions?
The premise is the same for Tableau Online as it would be for Tableau Server (locally hosted) or Tableau Public.
1. Make sure that your computer that you will host your dashboard refresh on has access to Tableau Online and has appropriate authentication privileges against the dashboard.
2. Copy the URL at the top of your screen when navigating to your dashboard. I imagine you may also want to add some URL Parameters since this will not be a user interaction dashboard. I would recommend:
:toolbard=no&:refresh=yes *Note: Here is a list of the different URL parameters you can use: Parameters for Embed Code - Tableau
3. Replace the "[URL GOES HERE]" with the URL you copied. Leave the quotes on either side
4. Copy the rest of the text into a Text document. When you save it, replace the .txt with .vbs (You may need to enable a Folder Options setting to see the extension .txt. To do this in a folder, click on Organize>Folder and Search Options. Click on the View Tab and disable "Hide Extensions for known file Types". If you are not familiar with this setting I would recommend turning it back on in order to not inadvertently change an extension you did not mean to.
5. Now you have a .vbs file that will open IE, navigate to your URL, and refresh every 30 seconds. To change the refresh period, replace the Wscript.Sleep 30000 with the amount of milliseconds you wish to refresh. IE: refresh every 15 minutes would be "Wscript.Sleep 900000" (15 min * 60 seconds * 1,000 = 900000)
6. If you would like to auto trigger this event, I would suggest using Task Scheduler and creating a basic task to trigger this event when your local user logs in (in an event of a restart or power failure).
7. If you have local authentication enabled, you will need to log in using the credentials before allowing the script to refresh the screen. If you are using something like SAML or OpenID then you can pass these credentials through to Tableau Server for logging in. More information on Authentication Methods is here: Authentication - Tableau
I did want to mention that if you are thinking about building out a web page specifically for your dashboard there is a continually refresh option in the head section of the web page. From the description I didn't think you were headed this route but wanted to bring it up just in case.
PS. I have attached the .vbs script with the .vbs extension as well as the .txt for your reference. The .vbs may not appear depending on the security policies of Tableau Community.
Curious if you every got this to work for you?