13 Replies Latest reply on Feb 15, 2019 2:52 PM by Madhu HR

Function refreshDataAsync() does not refresh the view

Karen Huang Sep 21, 2015 12:07 AM

Hi,

Got a task to refresh a real-time sheet which can be viewed via browser. Googled the Internet and copied a number of scripts but none works on my pc. I have the following codes in the script:

...

function RefreshViz(){
    alert("test");
    viz.refreshDataAsync();
    }

...

The function alert() works as a dialog box pops up:

However refreshDataAsync() does not seem to work as the view doesn't get updated.

This morning I stopped the Tableau service for some other reason whilst still having the htm file with the javascript running on Chrome. And I got this:

It seems a request was sent to the server! Then why didn't the view get updated? I tried on IE8, Chrome 45 and Firefox22.

Any idea would be appreciated.

Karen

1. Re: Function refreshDataAsync() does not refresh the view

Jerry Daru Sep 22, 2015 1:22 PM (in response to Karen Huang)

I had a difficult time with this as well. Are your data sources live or extract? Also, have you checked that you are able to refresh the data sources from outside the API?
Like Show 0 Likes(0)

Actions
2. Re: Function refreshDataAsync() does not refresh the view

Karen Huang Sep 22, 2015 4:40 PM (in response to Jerry Daru)

Hi Jerry,

It's live data with a connection to a SQL database. The dashboard can be refreshed either on Tableau Server or in its workbook. I can manually refresh the browser to get lastest data shown in the charts.

How did you fix your problem??

Thanks.
Like Show 0 Likes(0)

Actions
3. Re: Function refreshDataAsync() does not refresh the view

Jerry Daru Sep 23, 2015 11:37 AM (in response to Karen Huang)

For me the fix was to change our server settings to not use cached data for our live data sources
Like Show 0 Likes(0)

Actions
4. Re: Function refreshDataAsync() does not refresh the view

Karen Huang Sep 23, 2015 4:28 PM (in response to Jerry Daru)

I did it too. By default the Caching setting on our Tableau Server was 'Balanced' and was changed to 'Refresh more often'. But the refreshing problem is not fixed.

Thanks Jerry. There might be other issue in my Tableau environment. ...
Like Show 0 Likes(0)

Actions
5. Re: Function refreshDataAsync() does not refresh the view

Jerry Daru Sep 29, 2015 9:18 AM (in response to Karen Huang)

Are you using the trusted ticket method for accessing the data? Or, are you depending on the log in credentials of the person accessing the page?
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
6. Re: Function refreshDataAsync() does not refresh the view

Karen Huang Sep 30, 2015 7:52 PM (in response to Jerry Daru)

No Jerry. At the moment we are not using trusted authentication, but user credentials to access Tableau Server.

Cheers,
Like Show 0 Likes(0)

Actions
7. Re: Function refreshDataAsync() does not refresh the view

Tamas Foldi Oct 2, 2015 8:47 AM (in response to Karen Huang)

When you open your chrome's web inspector, do you see any javascript error? can you check your XHR queries and responses in network tab? are the related AJAX calls are successful?
Like Show 1 Likes(1)

Actions
8. Re: Function refreshDataAsync() does not refresh the view

Karen Huang Oct 4, 2015 10:19 PM (in response to Tamas Foldi)

Thanks Tamas. A couple of errors were found in my javascript codes which I copied from Internet: (1) tableau_v8.js file was not included in the html file; (2) non-existing tableauSoftware.viz() constructor instead of tableau.viz() was used to create a viz object.

However, after trying to fix them, I've attracted new errors. Seems an array, tableau.vizs[ ], is not defined in viz_v1.js? Not sure if it was due to a failed step where the array was to be created...

regards,
Like Show 0 Likes(0)

Actions
9. Re: Function refreshDataAsync() does not refresh the view

Tamas Foldi Oct 4, 2015 10:26 PM (in response to Karen Huang)

you should not include viz_v1.js directly, just tableau v8 js which declares that array.

could you post your current state of code?
Like Show 0 Likes(0)

Actions
10. Re: Function refreshDataAsync() does not refresh the view

Karen Huang Oct 4, 2015 10:39 PM (in response to Tamas Foldi)
Hi Tamas,

You are right. By removing viz_v1.js there is only one error left.

The htm file is attached. You need to change its file extension. As well as the link to the Tableau dashboard to be something local...

Thank you.

LivePunctRefreshScript.txt.zip 958 bytes
Like Show 0 Likes(0)

Actions
11. Re: Function refreshDataAsync() does not refresh the view

Tamas Foldi Oct 10, 2015 4:28 AM (in response to Karen Huang)
I fixed for you, find it attached.

This was the main issue:

window.setInterval(RefreshViz, 1000);

Here you should not use quotes when specifying the callback function.

LivePunctRefreshScript.txt.zip 753 bytes
Like Show 0 Likes(0)

Actions
12. Re: Function refreshDataAsync() does not refresh the view

Karen Huang Oct 11, 2015 4:25 PM (in response to Tamas Foldi)

Thanks Tamas. I see the problem. Now it works on my pc too.

Appreciate of your help. I spent quite some time trying to debugging this.

All the best.
Like Show 0 Likes(0)

Actions
13. Re: Function refreshDataAsync() does not refresh the view

Madhu HR Feb 15, 2019 2:52 PM (in response to Karen Huang)

Can you explain the steps how to use it and My requirement is that want i have 10 workbooks i want 5 of them to be showing refreshed data every 12 hours .Like DS will refresh 12 hours but users need to hit refresh button as they want output to be shared in a FTP location.for that i was using tabcmd but dashboard is only showing last refreshed data.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Function refreshDataAsync() does not refresh the view

1. Re: Function refreshDataAsync() does not refresh the view

2. Re: Function refreshDataAsync() does not refresh the view

3. Re: Function refreshDataAsync() does not refresh the view

4. Re: Function refreshDataAsync() does not refresh the view

5. Re: Function refreshDataAsync() does not refresh the view

6. Re: Function refreshDataAsync() does not refresh the view

7. Re: Function refreshDataAsync() does not refresh the view

8. Re: Function refreshDataAsync() does not refresh the view

9. Re: Function refreshDataAsync() does not refresh the view

10. Re: Function refreshDataAsync() does not refresh the view

11. Re: Function refreshDataAsync() does not refresh the view

12. Re: Function refreshDataAsync() does not refresh the view

13. Re: Function refreshDataAsync() does not refresh the view

Sign In or
Create your Account

Actions

More Like This

Incoming Links

Sign In or Create your Account

Sign In or
Create your Account