1 of 1 people found this helpful
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?
Andrew, is it possible for this vbs file to launch the URL using Edge?
Microsoft edge is categorized as a Modern Universal app rather than an executable program like IE is. You can however, utilize protocol activation to run Microsoft Edge, either from the command line or from the run menu.
You can launch Microsoft edge from the command line by doing the following:
(obviously replace tableau_server with your own url)
Because it is utilizing protocol activation, there is not a way that I know of to actually script the auto refresh. The list of protocols for Edge can be found in the AppxManifest.xml file located in the SystemsApp folder. If you find a way to script it though, please let me know or if you find an extension that will work.
Thank you very much for the information. Now that I know the limitations, I think it may be wise for me to find an alternative solution like an extension. I appreciate the response and will respond if I find anything useful.
1 of 1 people found this helpful
The ability to automatically refresh Tableau Server views in a browser at regular intervals, is not currently built into the product.
To voice your support for the inclusion of this feature in a future product release, add your vote to the following Community Idea: https://community.tableau.com/ideas/5774
A possible workaround is documented in the knowledge base article below.
Automatically Refresh Tableau Server Views in a Browser at Regular Intervals
Hope this helps!